#27088 [NEW]: ORA-00604 and ORA-01756 when ocilogon with NLS_LANG=Polish_Poland.EE8ISO8859P2

From: Marek dot Martofel at oracle dot com Operating system: Linux PHP version: 4.3.4 PHP Bug Type: OCI8 related Bug description: ORA-00604 and ORA-01756 when ocilogon with NLS_LANG=Polish_Poland.EE8ISO8859P2 Description: ------------ When you trye to use ocilogon() in any php code from Apache you can see: Warning: ocilogon(): OCISessionBegin: ORA-00604: error occurred at recursive SQL level 1 ORA-01756: quoted string not properly terminated in /usr/local/apache/htdocs/ocitest.php on line 2 where /usr/local/apache/htdocs/ocitest.php is some like: <?php $db_conn = ocilogon("scott","tiger", "RH9204"); $cmdstr = "select ename, sal from emp"; $parsed = ociparse($db_conn, $cmdstr); ociexecute($parsed); .... that happen only if you have NLS_LANG set to other then AMERICAN_AMERICA. Solution is to use: NLS_LANG=American_America.EE8ISO8859P2 or unset this environment variable. Reproduce code: --------------- Use following script to start Apache: #!/bin/bash export ORACLE_HOME=/u01/ora920/app/oracle/product/920 export ORACLE_SID=RH9204 export ORA_NLS33=/u01/ora920/app/oracle/product/920/ocommon/nls/admin/data export LD_LIBRARY_PATH=/u01/ora920/app/oracle/product/920/lib export NLS_LANG=Polish_Poland.EE8ISO8859P2 export APACHE_HOME=/usr/local/apache echo "Oracle Home: $ORACLE_HOME" echo "Oracle SID: $ORACLE_SID" echo Starting Apache $APACHE_HOME/bin/apachectl start now you can see the ORA-00604 error. Commenting out or seting NLS_LANG to American_America you can resolve this isue. -- Edit bug report at http://bugs.php.net/?id=27088&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=27088&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=27088&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=27088&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=27088&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=27088&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=27088&r=needscript Try newer version: http://bugs.php.net/fix.php?id=27088&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=27088&r=support Expected behavior: http://bugs.php.net/fix.php?id=27088&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=27088&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=27088&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=27088&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=27088&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=27088&r=dst IIS Stability: http://bugs.php.net/fix.php?id=27088&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=27088&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=27088&r=float