I use ora_login_user Waleed -----Original Message----- From: Mark Burgess [mailto:mburgess_nz@xxxxxxxxxxx]=20 Sent: Monday, July 12, 2004 10:33 PM To: oracle-l@xxxxxxxxxxxxx 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 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 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------