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
        SET @ret = 1
        RETURN @ret

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 

$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

Reply via email to