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] [EMAIL PROTECTED]

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] [EMAIL PROTECTED]

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

Reply via email to