Hi All,
Using Oracle 11gr2 on RHEL6.
Having a issue with NLS parameters.
I have used a DB Trigger to set the NLS parameters to set my searches case-insensitive;
conn test/test1;
create or replace trigger nls_set
after logon on schema
begin
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_COMP=LINGUISTIC';
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_SORT=BINARY_CI';
end nls_set;
/
After executing some queries, checking from nls_session_parameters found that NLS_COMP = 'BINARY' to the default value. The db trigger setting is not persistent.
I have tried setting at system level <alter system...scope=spfile>. though the parameters show the proper value, case-insensitive not working;
Any help appreciated.