#45099 [Fbk->Opn]: PROCEDURE xxx can't return a result set in the given context(same as in mysqli)
| From: | jani@php.net | Date: | Mon, 26 May 2008 23:46:19 +0000 |
| Subject: | #45099 [Fbk->Opn]: 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-125283@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: Feedback
+Status: Open
Bug Type: MySQL related
Operating System: Linux (all?)
PHP Version: 5.2.6
New Comment:
nevermind..
Previous Comments:
------------------------------------------------------------------------
[2008-05-26 23:44:38] jani@php.net
That's a mysql error, what does this has to do with PHP?
------------------------------------------------------------------------
[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