Calling a stored procedure
| From: | Dan Shirah | Date: | Fri, 30 Nov 2007 18:39:23 +0000 |
| Subject: | Calling a stored procedure | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-265307@lists.php.net to get a copy of this message | ||
Hello all,
I am having soem 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:
if ($num_rows > 0 && $barcode_id == "") {
echo "The query found ".$num_rows." row(s)";
$call_procedure = "CALL informix.updt_brcd_id_req('$case', '$event_date',
'$event_sequence', '$event_code')";
$call_result = $connect_id->query($call_procedure);
}
I get this error message: PHP Fatal error: Call to a member function query()
on a non-object
I have never tried to call a stored procedure in PHP before so I'm not even
sure if I am on the right track.
Any help is greatly appreciated.
Dan