• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
OUT parameters for Stored Routines?

#1
[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?


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.