#39759 [NEW]: Can't use stored procedures from PDO on Windows

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