php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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 Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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

Add a Patch

Pull Requests

Add a Pull Request

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-2023 The PHP Group
All rights reserved.
Last updated: Sat Jan 28 20:03:45 2023 UTC