From: mike at we11er dot co dot uk
Operating system: Windows XP
PHP version: 5.2.0
PHP Bug Type: PDO related
Bug description: Can't use stored procedures from PDO on Windows
Description:
------------
On the windows version of pdo_mysql, the nextRowset() method isn't
implemented for PDOStatement.
This means that when executing a stored procedure, it is impossible to
fetch all result sets, because all stored procedures return multiple
result sets (one contains a return value of some sort).
Because you can't fetch all result sets, all subsequent queries are
broken, with the following error/exception:
SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other
unbuffered queries are active. Consider using PDOStatement::fetchAll().
nextRowset() is /required/ to properly use stored procedures.
Reproduce code:
---------------
It should be possible to fetch all results from a stored procedure with
code like this:
$stmt = $db->prepare("CALL SomeProcedure()");
$stmt->execute();
do
{
$stmt->fetchAll();
} while ($stmt->nextRowset());
Intead the error message:
SQLSTATE[HYC00]: Optional feature not implemented
Is displayed. But I don't see how this can be optional in this case, it is
required.
--
Edit bug report at http://bugs.php.net/?id=39759&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=39759&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=39759&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=39759&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=39759&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=39759&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=39759&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=39759&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=39759&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=39759&r=support
Expected behavior: http://bugs.php.net/fix.php?id=39759&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=39759&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=39759&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=39759&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=39759&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=39759&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=39759&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=39759&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=39759&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=39759&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=39759&r=mysqlcfg
