PDO - SP Return Values supported?

Hey Guys,

I'm working with a SQL Server stored procedure that returns error codes;
here is a very simple snippet of the SP.

DECLARE @ret int
BEGIN
SET @ret = 1
RETURN @ret
END

I can't figure out how to access the return value in PDO; I'd prefer not to
use an OUT parameter, as alot of these Stored Procedures have already been
written. Here is an example of how I am currently calling the procedure in
PHP.

$stmt = $this->db->prepare("EXECUTE usp_myproc ?, ?");
$stmt->bindParam(1, 'mystr', PDO::PARAM_STR);
$stmt->bindParam(2, 'mystr2', PDO::PARAM_STR);
$rs = $stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

Is there a way to do this without an OUT parameter?



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php