#39759 [Opn->Bgs]: Can't use stored procedures from PDO on Windows

From: Date: Wed, 06 Dec 2006 17:14:35 +0000
Subject: #39759 [Opn->Bgs]: Can't use stored procedures from PDO on Windows
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-106018@lists.php.net to get a copy of this message 
 ID:               39759
 Updated by:       tony2001@php.net
 Reported By:      mike at we11er dot co dot uk
-Status:           Open
+Status:           Bogus
 Bug Type:         PDO related
 Operating System: Windows XP
 PHP Version:      5.2.0
 New Comment:

Duplicate of feature request #38842.


Previous Comments:
------------------------------------------------------------------------

[2006-12-06 17:09:57] mike at we11er dot co dot uk

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 this bug report at http://bugs.php.net/?id=39759&edit=1

Thread (20 messages)

« previous php.bugs (#106018) next »