By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,738 Members | 2,076 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,738 IT Pros & Developers. It's quick & easy.

logoff trigger does n't works

P: 15
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
Sep 7 '07 #1
Share this Question
Share on Google+
3 Replies


debasisdas
Expert 5K+
P: 8,127
As you have posted a question in articles esection it is being moved to Oracle
Forum.

MODERATOR.
Sep 7 '07 #2

amitpatel66
Expert 100+
P: 2,367
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.
Sep 7 '07 #3

P: 15
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
Sep 7 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.