+- 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: OUT parameters for Stored Routines? (/showthread.php?tid=25509)
OUT parameters for Stored Routines? - El Forum - 12-14-2009
[eluser]nofearinc[/eluser]
I wonder how to retrieve the OUT parameters from the stored routines. It works OK with in parameters only, but I'm not able to retrieve the OUT values. My error is:
-----------
Error Number: 1414
OUT or INOUT argument 3 for routine add_implicit is not a variable or NEW pseudo-variable in BEFORE trigger
-----------
I use this approach:
Code:
$mail = '[email protected]';
$pass = '123123';
$out_id = 0;
$sql = "CALL add_implicit(?, ?, ?)";
$params = array($mail, $pass, &$out_id);Any ideas how to bind the output parameters properly?