AFTER LOGON System Trigger

From: Mark Burgess <mburgess_nz_at_yahoo.co.nz>
Date: Tue, 13 Jul 2004 14:32:54 +1200 (NZST)
Message-ID: <20040713023254.94090.qmail@web51801.mail.yahoo.com>

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 IF sys.login_user = '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
-----------------------------------------------------------------

Received on Mon Jul 12 2004 - 21:29:51 CDT