Posted by Steve on 11/17/05 11:34

> I'm trying to execute a SQL stored procedure from PHP like so:

> $sql = "exec ('usp_Locations_Sel 5065')";

> However, any procedure that returns a result set doesn't make it back
> to PHP.

Not sure what you mean by "doesn't make it back". Do you get a PHP
error or is your $result empty or something else?

One possibility is that your stored proc is trying to return more than
one resultset - usually because it is returning the number of rows
affected as a second resultset. The PHP API doesn't handle this. To
stop it, in the stored proc add this line before the start of your
code:

SET NOCOUNT ON

---
Steve

[Back to original message]