Hi there!
I' having a logon trigger on 9.2.0.2 which sets
DBMS_SESSION.set_nls('nls_language','''GERMAN''');
DBMS_SESSION.set_nls('nls_territory','''GERMANY''');
But I'm getting the following error message:
ORA-00604: error occurred at recursive SQL level 1
ORA-04092: cannot SET NLS in a trigger
ORA-06512: at "SYS.DBMS_SESSION", line 141
ORA-06512: at line 2
This trigger works perfectly fine on 7.3.4 and 8.x.x
Error ORA-4092 just says that I can't do a commit or rollback in a trigger...
This 9.2.0.2 on HP-UX.
Any ideas?
Thanks,
Helmut
