Invoking any JSP or DDL related to JSP is altering NLS_SESSION_PARAMETER set on client side.
Hello All,
I have an issue where invoking any JSP or DDL related to JSP is altering NLS_SESSION_PARAMETER set.
For Example :
++ Create a logon database trigger to set the NLS_COMP and NLS_SORT to the LINGUISTIC and BINARY_CI value.
(or)
After logging into database from client, use the alter session statement to set the above NLS variables.
++ Verify the settings through below.
1) show parameter nls%;
2) select parameter, value from nls_Session_parameters where parameter in ('NLS_COMP','NLS_SORT');
3) select name, value from v$parameter where name in ('nls_sort','nls_comp');
++ In the same session issue any DDL statements related to java or invoke any JSP.
I have an issue where invoking any JSP or DDL related to JSP is altering NLS_SESSION_PARAMETER set.
For Example :
++ Create a logon database trigger to set the NLS_COMP and NLS_SORT to the LINGUISTIC and BINARY_CI value.
(or)
After logging into database from client, use the alter session statement to set the above NLS variables.
++ Verify the settings through below.
1) show parameter nls%;
2) select parameter, value from nls_Session_parameters where parameter in ('NLS_COMP','NLS_SORT');
3) select name, value from v$parameter where name in ('nls_sort','nls_comp');
++ In the same session issue any DDL statements related to java or invoke any JSP.
0