Link to home
Create AccountLog in
Avatar of kevbob650
kevbob650Flag for United States of America

asked on

PHP Oracle Warnings

I'm getting PHP Warnings that I'm not able to debug and can't find any useful explanations when searching:

$sql = "select PRODUCT from table where ... ";
            
      $rs = oci_parse($this->Connection,$sql);
      oci_execute($rs);

      if($row = oci_fetch_object($rs, OCI_ASSOC)) {
            $myobjects->product = $row->PRODUCT;
      }
      
PHP Warning:  oci_execute(): ORA-00936: missing expression
PHP Warning:  oci_fetch_object(): ORA-24374: define not done before fetch or execute and fetch in ...

Any assistance would be appreciated!
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
It is an issue of SELECT statement parameters or conditions you applied. Better post the full code of the statement.
Avatar of kevbob650

ASKER

It was a syntax error that I missed.  I need to check if the variables I am passing to the select statement are valid.