Calling a stored procedure

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

Relevant Pages

  • Re: [PHP] Calling a stored procedure
    ... I am having soem difficulty when trying to call an INFORMIX stored procedure ... I get this error message: PHP Fatal error: Call to a member function query ... You have to first instantiate the class. ...
    (php.general)
  • Re: Stored procedures, MySQL, and PHP
    ... I have PHP 5.2, Apache 2.0, and MySQL 5.0 ... My stored procedures work fine from the mysql command line ... Here is my stored procedure code: ...
    (comp.lang.php)
  • Re: Commands out of sync error
    ... connection at the top of the php page and then calling multiple stored ... When I call the 2nd stored procedure I'm ... Jerry Stuckle ... JDS Computer Training Corp. ...
    (comp.lang.php)
  • Re: Stored procedures, MySQL, and PHP
    ... I have PHP 5.2, Apache 2.0, and MySQL 5.0 ... My stored procedures work fine from the mysql command line ... Here is my stored procedure code: ...
    (comp.lang.php)
  • Re: Commands out of sync error
    ... connection at the top of the php page and then calling multiple stored ... When I call the 2nd stored procedure I'm ... JDS Computer Training Corp. ... Try calling it from the MySQL command line, ...
    (comp.lang.php)