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);

      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!
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
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


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