Why Am I Getting MySQL Error #1312 when Using a Simple Stored Procedure? -


I'm trying to learn how to use MySQL stored procedures MySQL accepted my process: 

  Practical Start SimpleProc () Select My; END

(In phpMyAdmin, I set for the delimiter. In the actual version is the name of the actual table rather than the meritable.).

But, when I call call simple; Call me the process with, call me error, "I get an error" # 1312 - Action Mediab. The simple pronoun can not return the result set in the given reference ".

I read that some versions of PHP or phpMyAdmin will not work with stored procedures.

I am using a local host running on Mac with MAMP 1.9. MySQL 5.1.44, PHP 5.2.13 & amp; 5.3.2, phpMyAdmin 3.2.5 Does anyone know if stored procedures will work with my set-up? Am I doing something wrong?

Thanks, Laxmi

Yes, some older versions of phpMyAdmin seem to have a bug, making you get 1312 error. This can happen when the stored procedures are called in which contains the SELECT statement from phpMyAdmin.

You can check the following posts for further reading:

  • (comments)
< P> This bug effect is only phpMyAdmin, and you will be able to call stored procedure anywhere.


Comments

Post a Comment