AW: Change NLS variables in logon trigger...

From: <v.schoen_at_inplan.de>
Date: Thu, 30 Jan 2003 01:28:47 -0800
Message-ID: <F001.0053E478.20030130012847@fatcity.com>

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:v.schoen_at_inplan.de <mailto:v.schoen_at_inplan.de> http://www.inplan.de <http://www.inplan.de/>

-----Ursprüngliche Nachricht-----
Von: Daiminger, Helmut [mailto:Helmut.Daiminger_at_KirchGruppe.de] 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

--

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

Author:
  INET: v.schoen_at_inplan.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 - 03:28:47 CST