PDO_PGSQL: out parameter support
| From: | Remo Laubacher | Date: | Sat, 18 Mar 2006 15:13:33 +0000 |
| Subject: | PDO_PGSQL: out parameter support | ||
| Groups: | php.pecl.dev | ||
| Request: | Send a blank email to pecl-dev+get-3622@lists.php.net to get a copy of this message | ||
I'm trying to call a stored procedure with PDO_PGSQL but without much success so far. I'm using the latest 5.1 php snap which is compiled with libpgsql 8.1.3 which should support out parameters..
This call
$stmt = $dbh->prepare("CALL test(:ret)");
returns this error:
Error!: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "CALL" at character 1
I also tried to use a ? instead of :ret..
Accessing the return value also didn't work
$stmt = $dbh->prepare("? = CALL test(?)");
$stmt = $dbh->prepare("? := test(?)");
$stmt = $dbh->prepare("? = test(123)");
....
What's wrong with my code or is there no support in PDO for such statements yet?
Thanks a lot!
Remo