CodeIgniter Forums
problem with stored procedure - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: problem with stored procedure (/showthread.php?tid=38440)



problem with stored procedure - El Forum - 02-08-2011

[eluser]bijufun[/eluser]
when i try to execute 2 store procedures one after other, I get following error:

-------------------------------------------------------------
A Database Error Occurred

Error Number: 2014

Commands out of sync; you can't run this command now
-------------------------------------------------------------


PLS HELP !!


problem with stored procedure - El Forum - 02-09-2011

[eluser]bijufun[/eluser]
"Commands out of sync; you can't run this command now"

I get this error in few store procedure only.. mostly when i try to execute 2 store procedure one after other though I do use free_result before executing new procedure.
and sometime in select statements.


problem with stored procedure - El Forum - 03-07-2012

[eluser]bleu[/eluser]
I have the same issue .

Has anybody found a solution?