-
logoff trigger does n't works
Hi
I created one logoff trigger . but tat does n't work properly
but log on trigger works properly. wat's the problem
I'm using oracle 9i with unix environment
coding
*********
create or replace trigger logoff_trig
before logoff on schema
begin
insert into logon_trig values (user,sysdate,'logging off');
end;
/
~
SQL> @logoff.sql
Trigger created.
SQL> select*from logon_trig;
no rows selected
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
/wd/arul>s
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Sep 7 11:22:09 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> select*from logon_trig;
no rows selected
-
First of all : ** what ** database user are you using ??? As we know (showed in http://asktom.oracle.com/pls/asktom/...:1844531724208 to db version 8i, but iirc valid to 9i also), triggers DO NOT FIRE to database users with DBA role... Another point, how is your _system_trig_enabled parameters ???
Regards,
Chiappa
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|