How to call stored Procedure in phpAdmin

[ravibachwala]

Hi,

I have created the a stored procedure. when i am trying to call that stored procedure i am getting a error.



#1312 - PROCEDURE 'procedurename' cannot return the return the result set.


Can anybody help me out

Regards,

Ravi

[danielsonchris]

Ravi,
I had a similiar issue and found that the mysqli driver needs an additional parameter seeded into it. Now, I haven't added this into the phpAdmin system, but I can show you what needs to be added.

Wherever the call is made in the phpAdmin code to call your stored procedure or inline SQL you must adjust the the system as follows:

PHP Code:

if (function_exists(‘mysqli_options’)) {
         mysqli_options($this->_connectionID, /*CLIENT_MULTI_RESULTS*/0×20000, 1);
      } 


This information was taken from:
Geek Building The Bridge Part 2 » Blog Archive » PHP Adodb’s mysqli call-stored-proc patch

I did use this with the PHP ADODB library set and posted my fix at:
Help please with adodb calling stored procedure in mysql db - PHPBuilder.com

Hope this helps!

Kind Regards,
Chris Danielson
MaxPowerSoft, LLC