Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 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
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
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
-- 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
![]() |
![]() |