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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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 Feb 11 17:03:15 CST 2025