PDO - SP Return Values supported?
| From: | Chris Schroll | Date: | Mon, 15 Jun 2009 18:22:33 +0000 |
| Subject: | PDO - SP Return Values supported? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-46229@lists.php.net to get a copy of this message | ||
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?