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