CodeIgniter Forums

Full Version: OUT parameters for Stored Routines?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

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:
$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?