Home » SQL & PL/SQL » SQL & PL/SQL » How to get NLS_LANG from other session (merged)
How to get NLS_LANG from other session (merged) [message #391285] Wed, 11 March 2009 11:29 Go to next message
isthisadagger
Messages: 14
Registered: April 2008
Location: Germany
Junior Member

Hello,

i am looking for a way to extend the statement below with a session id so i can see the parmeters from another session.

SELECT * FROM NLS_SESSION_PARAMETERS


Thanks in advance.
Re: How to get NLS_LANG from other session [message #391286 is a reply to message #391285] Wed, 11 March 2009 11:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: How to get NLS_LANG from other session (merged) [message #391288 is a reply to message #391285] Wed, 11 March 2009 11:36 Go to previous messageGo to next message
isthisadagger
Messages: 14
Registered: April 2008
Location: Germany
Junior Member

Thank you for the fast reply.

Does this mean i can not get the parameters of another session
and/or i can not extend this statement to show them?
Re: How to get NLS_LANG from other session (merged) [message #391290 is a reply to message #391288] Wed, 11 March 2009 11:49 Go to previous message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This means that you can't have parameter values (at least these ones) from other sessions.

Regards
Michel
Previous Topic: SQL Model Clause to Create Resultset without DDL or Collection
Next Topic: PL/SQL
Goto Forum:
  


Current Time: Tue Dec 06 02:14:00 CST 2016

Total time taken to generate the page: 0.08640 seconds