Change NLS variables in logon trigger...

From: Daiminger, Helmut <Helmut.Daiminger_at_KirchGruppe.de>
Date: Wed, 29 Jan 2003 23:38:46 -0800
Message-ID: <F001.0053E328.20030129233846@fatcity.com>

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Daiminger, Helmut
  INET: Helmut.Daiminger_at_KirchGruppe.de

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 30 2003 - 01:38:46 CST