Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h0UBopp15455 for ; Thu, 30 Jan 2003 05:50:51 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h0UBoom15450 for ; Thu, 30 Jan 2003 05:50:50 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id AAA65583; Thu, 30 Jan 2003 00:34:30 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0053E328; Wed, 29 Jan 2003 23:38:46 -0800 Message-ID: Date: Wed, 29 Jan 2003 23:38:46 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Daiminger, Helmut" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Daiminger, Helmut" Subject: Change NLS variables in logon trigger... Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2C831.FBF47590" ------_=_NextPart_001_01C2C831.FBF47590 Content-Type: text/plain 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 ------_=_NextPart_001_01C2C831.FBF47590 Content-Type: text/html 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

------_=_NextPart_001_01C2C831.FBF47590-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut INET: Helmut.Daiminger@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@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).