#42548 [NEW]: PROCEDURE xxx can't return a result set in the given context

From:	garethjo at usc dot edu	Date:	Tue, 04 Sep 2007 19:24:08 +0000
Subject:	#42548 [NEW]: PROCEDURE xxx can't return a result set in the given context
Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-117124@lists.php.net to get a copy of this message

From:             garethjo at usc dot edu
Operating system: Windows XP, Windows 2003
PHP version:      5.2.4
PHP Bug Type:     MySQLi related
Bug description:  PROCEDURE xxx can't return a result set in the given context

Description:
------------
All stored procedure call which would return a result set (and did in the
past) produces the error 

"PROCEDURE procedure.Name can't return a result set in the given context"

However the expected results are returned via command line and other mysql
clients.

Reproduce code:
---------------
test code can be found at:

http://128.125.64.37/bug.zip

Expected result:
----------------
resultset returned

Actual result:
--------------
PROCEDURE procedure.Name can't return a result set in the given context

-- 
Edit bug report at http://bugs.php.net/?id=42548&edit=1
-- 
Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=42548&r=trysnapshot44
Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=42548&r=trysnapshot52
Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=42548&r=trysnapshot60
Fixed in CVS:                 http://bugs.php.net/fix.php?id=42548&r=fixedcvs
Fixed in release:             http://bugs.php.net/fix.php?id=42548&r=alreadyfixed
Need backtrace:               http://bugs.php.net/fix.php?id=42548&r=needtrace
Need Reproduce Script:        http://bugs.php.net/fix.php?id=42548&r=needscript
Try newer version:            http://bugs.php.net/fix.php?id=42548&r=oldversion
Not developer issue:          http://bugs.php.net/fix.php?id=42548&r=support
Expected behavior:            http://bugs.php.net/fix.php?id=42548&r=notwrong
Not enough info:              http://bugs.php.net/fix.php?id=42548&r=notenoughinfo
Submitted twice:              http://bugs.php.net/fix.php?id=42548&r=submittedtwice
register_globals:             http://bugs.php.net/fix.php?id=42548&r=globals
PHP 3 support discontinued:   http://bugs.php.net/fix.php?id=42548&r=php3
Daylight Savings:             http://bugs.php.net/fix.php?id=42548&r=dst
IIS Stability:                http://bugs.php.net/fix.php?id=42548&r=isapi
Install GNU Sed:              http://bugs.php.net/fix.php?id=42548&r=gnused
Floating point limitations:   http://bugs.php.net/fix.php?id=42548&r=float
No Zend Extensions:           http://bugs.php.net/fix.php?id=42548&r=nozend
MySQL Configuration Error:    http://bugs.php.net/fix.php?id=42548&r=mysqlcfg


   

Thread (19 messages)

• garethjo at usc dot eduTue, 04 Sep 2007 19:24:08 +0000
  • jani@php.netTue, 04 Sep 2007 22:34:09 +0000#42548 [Opn->Fbk]: PROCEDURE xxx can't return a result set in the given context
  • garethjo at usc dot eduWed, 05 Sep 2007 00:10:23 +0000#42548 [Fbk->Opn]: PROCEDURE xxx can't return a result set in the given context
  • jani@php.netThu, 06 Sep 2007 22:31:43 +0000#42548 [Opn->Fbk]: PROCEDURE xxx can't return a result set in the given context
  • garethjo at usc dot eduFri, 07 Sep 2007 14:50:19 +0000#42548 [Fbk->Opn]: PROCEDURE xxx can't return a result set in the given context
  • al dot smith at aeschi dot ch dot eu dot orgFri, 07 Sep 2007 18:00:18 +0000#42548 [Com]: PROCEDURE xxx can't return a result set in the given context
  • jani@php.netSun, 09 Sep 2007 10:42:13 +0000#42548 [Opn->Asn]: PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!)
  • uwendel at mysql dot comTue, 11 Sep 2007 10:00:30 +0000#42548 [Com]: PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!)
  • garethjo at usc dot eduTue, 11 Sep 2007 15:54:05 +0000#42548 [Asn]: PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!)
  • al dot smith at aeschi dot ch dot eu dot orgTue, 11 Sep 2007 17:44:26 +0000#42548 [Com]: PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!)
  • uwendel at mysql dot comWed, 12 Sep 2007 08:55:24 +0000#42548 [Com]: PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!)
  • garethjo at usc dot eduWed, 12 Sep 2007 16:42:59 +0000#42548 [Asn]: PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!)
  • Al dot Smith at aeschi dot ch dot eu dot orgTue, 02 Oct 2007 20:47:37 +0000#42548 [Com]: PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!)
  • ajs at ictpro dot chSun, 21 Oct 2007 14:35:13 +0000#42548 [Com]: PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!)
  • hholzgra@php.netMon, 19 Nov 2007 18:21:20 +0000#42548 [Asn]: PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!)
  • hholzgra@php.netMon, 19 Nov 2007 18:22:02 +0000#42548 [Asn]: PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!)
  • hholzgra@php.netMon, 19 Nov 2007 20:07:46 +0000#42548 [Asn]: PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!)
  • garethjo at usc dot eduMon, 19 Nov 2007 20:37:23 +0000#42548 [Asn]: PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!)
  • hholzgra@php.netTue, 01 Jan 2008 16:51:26 +0000#42548 [Asn->Csd]: PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!)