#27088 [Com]: ORA-00604 and ORA-01756 when ocilogon with NLS_LANG=Polish_Poland.EE8ISO8859P2
ID: 27088
Comment by: robert dot ranftler at bau-data dot co dot at
Reported By: Marek dot Martofel at oracle dot com
Status: No Feedback
Bug Type: OCI8 related
Operating System: Linux
PHP Version: 4.3.4
New Comment:
I have the same problem with Version 4.3.9 and Oracle 9.2 on RedHat
Enterprise Serve 3. Has Anybody any Idea for a solution????
Previous Comments:
------------------------------------------------------------------------
[2004-02-03 08:09:10] sniper@php.net
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.
------------------------------------------------------------------------
[2004-01-29 16:54:47] sniper@php.net
Please try using this CVS snapshot:
http://snaps.php.net/php4-STABLE-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php4-win32-STABLE-latest.zip
------------------------------------------------------------------------
[2004-01-29 11:53:41] Marek dot Martofel at oracle dot com
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 this bug report at http://bugs.php.net/?id=27088&edit=1
Thread (5 messages)