|
|
| Re: howto check and change NLS and character set of AS [message #116904 is a reply to message #116871] |
Fri, 22 April 2005 18:57   |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
It depends on the version. I stand to be corrected, but from what I recall it's not set in 9iAS 9.0.2 when connecting through MOD_PLSQL. In 9.0.1 it was set. It's for globalization reasons. Capture your session nls settings and save of display them.
select parameter, value from nls_session_parameters where parameter like '%';
You can compare those settings to the defaults in v$parameter. You can also see what they look like immediately after App server login by trapping them with a logon trigger. You can identify your app server connections by looking in v$session for some reliable signature (like program etc). Of course the session deafults could be changed after the login trigger fires, so I'd check them again somewhere in your app code.
This will isolate the session info for your current session.
select *
FROM v$session
where sid = ( select sid from v$mystat where rownum = 1 ); |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
