Executing a stored procedure with PHP

[mrsquash]

Hello all,

 

I am having some difficulty when trying to call an INFORMIX stored procedure with PHP.

 

I have verified that the if() condition is true and all of the parameters I am passing are valid. However, when I run the following:

 

Connection

if (!$connect_id = ifx_connect("$database@$host", $user, $pass)) { // THE ACTUAL CONNECTION
   echo "Unable to connect to Informix Database\n"; // DISPLAY IF CONNECTION FAILS
   exit();
}

 

Calling the procedure

if ($num_rows > 0 && $barcode_id == "") {
echo "The query found ".$num_rows." row(s)";
$call_procedure = ifx_prepare("CALL informix.updt_brcd_id_req($case, $event_date, $event_sequence, $event_code)", $connect_id);
$call_result = ifx_do($connect_id, $call_procedure);
} 

 

I get these Errors:

PHP Warning: ifx_prepare() [function.ifx-prepare]: Prepare fails (E [sqlSTATE=42 000 SQLCODE=-201])

PHP Warning: Wrong parameter count for ifx_do()

 

I have looked all over the web but i cannot find a solution.

 

ny help is appreciated.