#32190 [Opn->Csd]: NLS ERROR OCISessionBegin: ORA-00604 with NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15
| From: | marco dot manngatter at ecg-leipzig dot de | Date: | Fri, 04 Mar 2005 11:59:14 +0000 |
| Subject: | #32190 [Opn->Csd]: NLS ERROR OCISessionBegin: ORA-00604 with NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-77423@lists.php.net to get a copy of this message | ||
ID: 32190
User updated by: marco dot manngatter at ecg-leipzig dot de
Reported By: marco dot manngatter at ecg-leipzig dot de
-Status: Open
+Status: Closed
Bug Type: OCI8 related
Operating System: SuSE Linux 9.2
PHP Version: 5CVS-2005-03-04 (dev)
New Comment:
going with this vars
LC_ALL=german
LANG=german
by
marco manngatter
Previous Comments:
------------------------------------------------------------------------
[2005-03-04 12:56:20] marco dot manngatter at ecg-leipzig dot de
PHPINFO
oci8
OCI8 Support enabled
Revision $Revision: 1.183.2.17 $
Oracle Version 9.2
Compile-time ORACLE_HOME /usr/share/oracle9
Libraries Used no value
_SERVER["SERVER_SIGNATURE"] <ADDRESS>Apache/1.3.33 Server at linux.site
Port 80</ADDRESS>
_ENV["NLS_LANG"] GERMAN_GERMANY.WE8ISO8859P15
ORACLE_SID=RH9204
PATH=/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/opt/kde3/bin:/usr/share/oracle9/bin
ORA_HOME=/usr/share/oracle9
ORA_NLS33=/usr/share/oracle9/ocommon/nls/admin/data
ORACLE_HOME=/usr/share/oracle9
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15
LC_ALL=german
LANG=german
------------------------------------------------------------------------
[2005-03-04 12:38:44] marco dot manngatter at ecg-leipzig dot de
Description:
------------
ocilogon works with NLS_LANG = NLS_LANG=AMERICAN
!!!!DOES NOT WORK WITH !!!
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15
Reproduce code:
---------------
phpcode:
$user = "test";
$pw = "test";
$db = "gabi.dv.cng";
$conn = ocilogon($user,$pw,$db);
Expected result:
----------------
Warning: ocilogon(): OCISessionBegin: ORA-00604: error occurred at
recursive SQL level 1 ORA-01756: quoted string not properly terminated
in
Actual result:
--------------
with ociinternaldebug(1);
OCIDebug: _oci_open_server new conn=0 dname=gabi.dv.cng
Warning: ocilogon(): OCISessionBegin: ORA-00604: error occurred at
recursive SQL level 1 ORA-01756: quoted string not properly terminated
in /srv/www/htdocs/index.php on line 9
OCIDebug: _oci_open_session: FAILURE -> CLEANUP called
OCIDebug: START _oci_close_session: logging-off sess=0
OCIDebug: _oci_close_session: logging-off DEAD session
OCIDebug: oci_do_connect: FAILURE -> CLEANUP called
OCIDebug: START _oci_conn_list_dtor: id=0
OCIDebug: END _oci_conn_list_dtor: id=0
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=32190&edit=1