AW: Change NLS variables in logon trigger...

[v . schoen]

Title: Nachricht

Hi Helmut,

 

did you grant "ALTER SESSION" to your database users?

 

regards

Volker Schoen
INPLAN RUHR
Informationstechnik GmbH
Tel.:  +49 208 / 65 91 - 950
Fax:  +49 208 / 65 91 - 980
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de

-----Ursprüngliche Nachricht-----
Von: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 30. Januar 2003 08:39
An: Multiple recipients of list ORACLE-L
Betreff: Change NLS variables in logon trigger...

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