php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #32190 NLS ERROR OCISessionBegin: ORA-00604 with NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15
Submitted: 2005-03-04 12:38 UTC Modified: 2005-03-04 12:59 UTC
From: marco dot manngatter at ecg-leipzig dot de Assigned:
Status: Closed Package: OCI8 related
PHP Version: 5CVS-2005-03-04 (dev) OS: SuSE Linux 9.2
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: marco dot manngatter at ecg-leipzig dot de
New email:
PHP Version: OS:

 

 [2005-03-04 12:38 UTC] 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-03-04 12:56 UTC] 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:59 UTC] marco dot manngatter at ecg-leipzig dot de 
going with this vars

LC_ALL=german
LANG=german

by 

marco manngatter
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sun Dec 22 01:01:30 2024 UTC