Doc #69894 [Opn->Csd]: PDO stored procedure out parameters don't work

Edit report at https://bugs.php.net/bug.php?id=69894&edit=1 ID: 69894 Updated by: adambaratz@php.net Reported by: ezequielcicala at hotmail dot com Summary: PDO stored procedure out parameters don't work -Status: Open +Status: Closed Type: Documentation Problem Package: PDO Core Operating System: Windows 7 PHP Version: 5.6.10 -Assigned To: +Assigned To: adambaratz Block user comment: N Private report: N New Comment: Closing, since the referenced documentation at present only has three examples. None of the remaining examples create a stored procedure. Previous Comments: ------------------------------------------------------------------------ [2015-06-21 05:55:58] ezequielcicala at hotmail dot com Description: ------------ --- From manual page: http://www.php.net/pdo.prepared-statements --- As per the current implementation, out parameters won't work. Trying to execute the code in examples 4 and 5 will throw the error: "SQLSTATE[42000]: Syntax error or access violation: 1414 OUT or INOUT argument 3 for routine test_table.baz is not a variable or NEW pseudo-variable in BEFORE trigger". Even when setting the attribute PDO::ATTR_EMULATE_PREPARES to 0, the bound variables won't be updated with the out parameters. This issue has been reported and explained here: https://bugs.mysql.com/bug.php?id=69206 and here: https://bugs.php.net/bug.php?id=64640. Expected result: ---------------- Execution of the stored procedure. Actual result: -------------- SQLSTATE[42000]: Syntax error or access violation: 1414 OUT or INOUT argument 3 for routine test_table.baz is not a variable or NEW pseudo-variable in BEFORE trigger ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=69894&edit=1