OraFAQ Forum: SQL & PL/SQL » Question

Home » SQL & PL/SQL » SQL & PL/SQL » Question | nls_session_parameters (oracle 11.2g , plsql developer 8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Question | nls_session_parameters [message #524752]

Mon, 26 September 2011 09:16

Sarlula
Messages: 18
Registered: September 2010

Junior Member

Hello,

I just upgraded my version of my oracle from 9 to 11.2g.

When I tried to execute some queries in PL/SQL i keep getting an
annoying error :

"ORA-01843 not a valid month."

I realized that if I execute the following query:

alter session set NLS_DATE_LANGUAGE=AMERICAN;

before every query that I want to execute, then it's executed fine.

I preformed the next queries:
1.

 select * from nls_database_parameters;

select * from nls_instance_parameters;

select * from nls_session_parameters;

and I saw that the fields in the "nls_session_parameters" view
are not derived from "nls_database_parameters" \ "nls_instance_parameters".

How can I derive the parameters from the instance\database view into the session view?
I want that the "nls_date_language" parameter will always be 'AMERICAN'.

Can it be done?

Report message to a moderator

Re: Question | nls_session_parameters [message #524754 is a reply to message #524752]

Mon, 26 September 2011 09:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>annoying error :
while you may have found an viable work around,
consider modifying application code to make it independent of DB or session settings;
by using TO_CHAR() or TO_DATE() function as needed.

Report message to a moderator