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