PDO_PGSQL: out parameter support

From: 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

« previous php.pecl.dev (#3622) next »