Oracle & NLS : Access from PHP
| From: | Robert Mena | Date: | Wed, 27 Feb 2002 18:50:24 +0000 |
| Subject: | Oracle & NLS : Access from PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-86448@lists.php.net to get a copy of this message | ||
Hi,
I have some script to access an Oracle database using
stored procedures. When I access a development
database everything runs fine. When I access the
production database I get errors PLS-00553: character
set name is not recognized ORA-06550.
The problem seems to be related to NLS. So in the
beginning of the script I've put :
putenv("ORACLE_BASE=/u01/app/oracle") ;
putenv("ORACLE_HOME=/u01/app/oracle/product/8.1.7");
putenv("ORA_NLS33=/u01/app/oracle/product/8.1.7/ocommon/nls/admin/data/")
;
putenv("ORACLE_SID=MYSID") ;
putenv("NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1") ;
But the error continues. The remote database has the
following parametes (select * from
nls_database_parameters)
'NLS_LANGUAGE','AMERICAN'
'NLS_TERRITORY','AMERICA'
'NLS_CURRENCY','$'
'NLS_ISO_CURRENCY','AMERICA'
'NLS_NUMERIC_CHARACTERS','.,'
'NLS_CHARACTERSET','WE8ISO8859P1'
'NLS_CALENDAR','GREGORIAN'
'NLS_DATE_FORMAT','DD-MON-RR'
'NLS_DATE_LANGUAGE','AMERICAN'
'NLS_SORT','BINARY'
'NLS_TIME_FORMAT','HH.MI.SSXFF AM'
'NLS_TIMESTAMP_FORMAT','DD-MON-RR HH.MI.SSXFF AM'
'NLS_TIME_TZ_FORMAT','HH.MI.SSXFF AM TZH:TZM'
'NLS_TIMESTAMP_TZ_FORMAT','DD-MON-RR HH.MI.SSXFF AM
TZH:TZM'
'NLS_DUAL_CURRENCY','$'
'NLS_COMP','BINARY'
'NLS_NCHAR_CHARACTERSET','WE8ISO8859P1'
'NLS_RDBMS_VERSION','8.1.7.0.1'
My development database has the following settings :
SQL> select * from nls_database_parameters;
PARAMETER VALUE
------------------------------
----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET US7ASCII
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF
AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF
AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_NCHAR_CHARACTERSET US7ASCII
NLS_RDBMS_VERSION 8.1.7.0.1
Help! :)
Rt.
__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com