Calling stored procedure with Out parameter using PDO

by

It would seem that there is a bug at work here, best solution I’ve found is this:

http://www.php.net/manual/en/pdo.prepared-statements.php#101993

From the comment at the link above:

$dbh->query("CALL SomeStoredProcedure($someInParameter1, $someInParameter2, @someOutParameter)"); 
$dbh->query("SELECT @someOutParameter");

// OR, if you want very much to use PDO.Prepare(),
// insert "SELECT @someOutParameter" in your stored procedure and then use:

$stmt = $dbh->prepare("CALL SomeStoredProcedure(?, ?)"); 
$stmt ->execute(array($someInParameter1, $someInParameter2));

See also this: https://stackoverflow.com/a/4502524/815386

More Related Contents:

  1. PHP – Using PDO with IN clause array
  2. pdo prepared statements with wildcards
  3. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  4. Insert multiple rows with PDO prepared statements
  5. Replacing mysql_* functions with PDO and prepared statements
  6. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  7. When *not* to use prepared statements?
  8. PDO error: SQLSTATE[HY000]: General error: 2031
  9. Use of PDO in classes [duplicate]
  10. Error while using PDO prepared statements and LIMIT in query [duplicate]
  11. Can I mix MySQL APIs in PHP?
  12. Can I bind an array to an IN() condition in a PDO query?
  13. PDOException “could not find driver”
  14. Row count with PDO
  15. PDO get the last ID inserted
  16. How do I use password hashing with PDO to make my code more secure? [closed]
  17. MySQLi prepared statements error reporting [duplicate]
  18. How to view query error in PDO PHP
  19. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  20. Insert/update helper function using PDO
  21. Resetting array pointer in PDO results
  22. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  23. PDO::PARAM for type decimal?
  24. Alternative for mysql_num_rows using PDO
  25. Unknown database error in PHP but it exists in PHPMyAdmin
  26. How do detect that transaction has already been started?
  27. return multiple response data in one response
  28. How can I pass an array of PDO parameters yet still specify their types?
  29. Using Prepared Statement, how I return the id of the inserted row?
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment