#42548 [Opn->Fbk]: PROCEDURE xxx can't return a result set in the given context

From:	jani@php.net	Date:	Tue, 04 Sep 2007 22:34:09 +0000
Subject:	#42548 [Opn->Fbk]: PROCEDURE xxx can't return a result set in the given context
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-117137@lists.php.net to get a copy of this message

 ID:               42548
 Updated by:       jani@php.net
 Reported By:      garethjo at usc dot edu
-Status:           Open
+Status:           Feedback
 Bug Type:         MySQLi related
 Operating System: Windows XP, Windows 2003
 PHP Version:      5.2.4
 New Comment:

Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves. 

A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external 
resources such as databases, etc. If the script requires a 
database to demonstrate the issue, please make sure it creates 
all necessary tables, stored procedures etc.

Please avoid embedding huge scripts into the report.




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

[2007-09-04 19:24:08] garethjo at usc dot edu

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


   

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!!)