Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » NLS_SESSION_PARAMETER
NLS_SESSION_PARAMETER [message #76594] Thu, 16 January 2003 01:44 Go to next message
Peach
Messages: 2
Registered: January 2003
Junior Member
I wrote a PL/SQL code for showing all NLS parameters executed throught Oracle iAS. The value of some parameters in NLS_SESSION_PARAMETER are different from using SQL query data by SQL*Plus (from client that not set any NLS parameters on) such as NLS_DATE_FORMAT = 'DD MON RRRR' from the PL/SQL code, NLS_DATE_FORMATE = 'DD-MON-RR' from SQL*Plus.

I would like to know where the value of each parameter in NLS_SESSION_PARAMETER table come from is and how I can force it to my format (from the server, not in the code -- DBMS.SET_NLS)?

Thanks
Re: NLS_SESSION_PARAMETER [message #76595 is a reply to message #76594] Fri, 17 January 2003 01:12 Go to previous message
Peach
Messages: 2
Registered: January 2003
Junior Member
let me more explain:

1. Query by logging in directly to the host:
SQL> select * from nls_session_parameters where parameter = 'NLS_DATE_FORMAT';

PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_DATE_FORMAT DD-MON-RR

************************************************

2. Set the NLS_DATE_FORMAT in init.ora:
NLS_DATE_FORMAT=DD/MM/YY

************************************************

3. Shutdown and Startup DB (Oracle 8.1.7).

4. Query by logging in directly to the host (again):
SQL> select * from nls_session_parameters where parameter = 'NLS_DATE_FORMAT';

PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_DATE_FORMAT DD/MM/YY

************************************************

5. Run PL/SQL code that containing the SQL statement as the 1st and 4th via a web browser (served by Oracle iAS):

-----------------
NLS Session is
-----------------
Parameters Values
------------------------ ------------------
NLS_DATE_FORMAT DD MON RRRR

************************************************

# Why is NLS_DATE_FORMAT = 'DD MON RRRR'?
It should be NLS_DATE_FORMAT = 'DD/MM/YY' or not?

# If Oracle iAS can specify the NLS parameter, how can I do?
(I would []not[] like to specify its from my code as using DBMS_SESSION.SET_NLS or other)

Regards
Previous Topic: 9iAS install err oracle.swd.jre.1.1.8.10.0
Next Topic: 9i install - AMD processor - NT 4.0 sp6 - JREW
Goto Forum:
  


Current Time: Thu Mar 28 09:28:12 CDT 2024