Bug #57626 [Opn->Dup]: Stored procedure and RETURN

Edit report at https://bugs.php.net/bug.php?id=57626&edit=1 ID: 57626 Updated by: adambaratz@php.net Reported by: aranna at free dot fr Summary: Stored procedure and RETURN -Status: Open +Status: Duplicate Type: Bug Package: PDO DBlib Operating System: RH PHP Version: 5.2.1 Block user comment: N Private report: N New Comment: This is the same issue described in #50555. Previous Comments: ------------------------------------------------------------------------ [2007-04-19 17:19:18] wez@php.net I'm trying to tell you that you should use ODBC if you want this to work, as PDO_DBLIB doesn't currently support this. ------------------------------------------------------------------------ [2007-04-19 16:50:10] aranna at free dot fr Why using ODBC when as you said i use PDO_DBLIB with Freetds API ? If you use standart Sybase api (sybase_connect, etc..) you can get RETURN value. ------------------------------------------------------------------------ [2007-04-19 08:26:28] wez@php.net oh, sybase eh? I'm guessing that you're using PDO_DBLIB then. My suggestion is to use PDO_ODBC and use the freetds ODBC driver and then bind this_id as an out parameter. ------------------------------------------------------------------------ [2007-04-19 08:19:53] wez@php.net Can you do it with mysqli? I don't believe that the mysql client library provides this functionality. ------------------------------------------------------------------------ [2007-04-19 03:27:30] aranna at free dot fr Description: ------------ Here the content of a sybase stored procedure with return a value of a field at the end like : ... END END COMMIT TRAN RETURN @this_id END Impossible to get @id_fax with PDO. RETURN values are not available. Reproduce code: --------------- Nothing. Expected result: ---------------- Return value of @this_id Actual result: -------------- No output field... ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=57626&edit=1