RE: AFTER LOGON System Trigger

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Tue, 13 Jul 2004 01:19:04 -0400
Message-ID: <42BBD772AC30EA428B057864E203C99927443E@MSGBOSCLF2WIN.DMN1.FMR.COM>

I use ora_login_user

Waleed

-----Original Message-----

From: Mark Burgess [mailto:mburgess_nz_at_yahoo.co.nz]=20 Sent: Monday, July 12, 2004 10:33 PM
To: oracle-l_at_freelists.org
Subject: AFTER LOGON System Trigger

Hi,

I am trying to record the logon even for a certain user with the following trigger code:

CREATE OR REPLACE TRIGGER SESS_JOB_QUEUE AFTER LOGON ON DATABASE BEGIN=20 IF sys.login_user =3D 'DISCO_SCH' THEN

do something;
end if;

END; ..

Whenever I try and connect as this user that I am trying to capture I get the following:

SQL*Plus: Release 9.2.0.5.0 - Production on Tue Jul 13 11:49:59 2004

ERROR:
ORA-04088: error during execution of trigger 'SYS.SESS_JOB_QUEUE'
ORA-01403: no data found
ORA-06512: at line 20

I would have thought the sys.login_user function would have been populated by this session when trying to login. I am not sure what I am missing here as a similar trigger on 'AFTER SERVERERROR' works fine.

Has anyone encountered something similar? Platform is Win XP Pro, 9.2.0.5 with 9.2.0.5 patch 2 applied.

Regards,

Mark

Find local movie times and trailers on Yahoo! Movies. http://au.movies.yahoo.com

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

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


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Jul 13 2004 - 00:16:12 CDT