#45099 [Opn->Fbk]: PROCEDURE xxx can't return a result set in the given context(same as in mysqli)

From: Date: Mon, 26 May 2008 23:44:38 +0000
Subject: #45099 [Opn->Fbk]: PROCEDURE xxx can't return a result set in the given context(same as in mysqli)
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-125282@lists.php.net to get a copy of this message 
 ID:               45099
 Updated by:       jani@php.net
 Reported By:      carsten at brandt-henke dot de
-Status:           Open
+Status:           Feedback
 Bug Type:         MySQL related
 Operating System: Linux (all?)
 PHP Version:      5.2.6
 New Comment:

That's a mysql error, what does this has to do with PHP?


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

[2008-05-26 22:27:28] carsten at brandt-henke dot de

Description:
------------
same problem as described here for mysqli (
http://bugs.php.net/bug.php?id=42548 ) seems to
exist in the mysql
extension. I get the same error message when trying to call a PROCEDURE
in MySQL.

The Error-Message:

1312 - PROCEDURE databsename.select_user_login can't return a result
set in the given context )

Reproduce code:
---------------
procedure has been added by sql-query:

DELIMITER |

CREATE PROCEDURE select_user_login 
(
  IN  v_email     varchar(128),
  IN  v_password  varchar(32)
)
BEGIN
     SELECT  user_id, username  FROM  user  WHERE  user.email =
v_email;
END|

DELIMITER ;

-------
php-code:

$res = mysql_query("CALL select_user_login('$email', '$pw')");

Expected result:
----------------
well, no error ;-)

Actual result:
--------------
MySQL-Error 

1312 - PROCEDURE databsename.select_user_login can't return a result
set in the given context )


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=45099&edit=1

Thread (3 messages)

« previous php.bugs (#125282) next »