PHP interpreter gets undefined constant OCI_COMMIT_ON_SUCCESS with ADODB

php oracle11g interpreter adodb oracle-call-interface
adiego73 picture adiego73 · Mar 26, 2012 · Viewed 12.5k times · Source


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!

Answer

Scott M. picture Scott M. · Mar 26, 2012

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.

Related questions

Getting error in console : Failed to load resource: net::ERR_CONNECTION_RESET

I have refresh my application page and getting this error in console Failed to load resource: net::ERR_CONNECTION_RESET. I have tried to re-install the XAMPP version but this doesnt work for me.

Read More
Call to undefined function oci_connect, php_oci8_12c.dll, windows 8.1, php5.6.6

I have a simple php script: <?php $db_user = 'myusername'; $db_pass = 'mypassword'; $db_sid = 'mysid'; $conn = oci_connect( $db_user, $db_pass, $db_sid ); ?> When I run it (from a browser or from the command line), I …

Read More
How to use oracle client 11.2 with php (xampp) on win7 x64

I just installed an acutal XAMPP on my win7 (x64) PC to write some PHP scripts to connect to an oracle DB. I also have a normal oracle 11.2.0 client installed (PATH and ORACLE_HOME are set correctly). The client is …

Read More