phporacle11ginterpreteradodboracle-call-interface

PHP interpreter gets undefined constant OCI_COMMIT_ON_SUCCESS with ADODB


I wrote a php script that must be run on the php interpreter (Without Apache), which uses the adodb library with an Oracle database, but when I try to run it, I'm getting the following error: 

PHP Notice:  Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed 'OCI_COMMIT_ON_SUCCESS' in c:\proyect\backend\libraries\adodb\adodb.inc.php on line 4248


I've checked, and have both the php_oci8 and php_oci8_11g enabled, so the constant SHOULD be defined. Also, when I run this script WITH Apache, it works without any problems.

Thanks in advance!

Solution

  • After a quick search I found this page. If you don't have the oracle extension enabled in your php.ini then the constant is undefined. Try searching for the line

    ;extension=php_oci8.dll

    in your php.ini and remove the semicolon to uncomment it. Then, restart Apache to load the module and see if it connects.

    EDIT:

    Try dumping the php.ini variables by doing something like print_r(ini_get_all()) and see what is set and what isn't. You may be using a different php.ini for the command line.