logoff trigger does n't works

[arulkumara]

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

[debasisdas]

As you have posted a question in articles esection it is being moved to Oracle
Forum.

MODERATOR.

[amitpatel66]

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

Try from SQL PLUS and post back if its working or not. Because I tried and it works fine for me.

[arulkumara]

Try from SQL PLUS and post back if its working or not. Because I tried and it works fine for me.

ya it works properly for me also

i done one mistake in table creation