OraFAQ Forum: SQL & PL/SQL » About System triggers

Home » SQL & PL/SQL » SQL & PL/SQL » About System triggers

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

About System triggers [message #35784]

Mon, 15 October 2001 22:42

akkiraju kiran kumar
Messages: 6
Registered: October 2001

Junior Member

Please help any body
My problem is
I am writing a System trigger on a particular schema
In that i am giving the dbms_output.put_line('hello');

when i login into that particular schema the message was not displaying.

in my login file i am given the set serveroutput on also
eventhough it is not working

----------------------------------------------------------------------

Report message to a moderator

Re: About System triggers [message #35786 is a reply to message #35784]

Tue, 16 October 2001 00:54

Yuvraj Thapa
Messages: 28
Registered: May 2001

Junior Member

Can U please tell me how to write system trigger?
according to my experience set serveroutput has no effect in scripts.
Thanks,
Yuvraj

----------------------------------------------------------------------

Report message to a moderator

Re: About System triggers [message #35833 is a reply to message #35784]

Wed, 17 October 2001 14:38

oraboy
Messages: 97
Registered: October 2001

Member

I guess serveroutput parameter comes into effect only after successful login..and hence your dbms_output doesnt have any effect.
(since you are trying on logon time)
Regards
oraboy

----------------------------------------------------------------------

Report message to a moderator

Re: About System triggers [message #35971 is a reply to message #35784]

Fri, 26 October 2001 12:25

Barry Johnson
Messages: 1
Registered: October 2001

Junior Member

Login Triggers execute as an "independent transaction". I assume, therefore, that the DBMS_Output is happening "out of band" with respect to the current session and is not part of the cached output associated with the session regardless of what you try?

I assume its somehow similar to the restriction that Login Triggers can't - according to the documentattion - have DDL statements?

----------------------------------------------------------------------

Report message to a moderator

About System triggers [message #36454 is a reply to message #35786]

Wed, 28 November 2001 21:57

Sridhar J
Messages: 5
Registered: November 2001

Junior Member

let me know how to write a System triggers to delete the table entries for 3rd day

----------------------------------------------------------------------

Report message to a moderator

Re: About System triggers [message #36457 is a reply to message #35786]

Wed, 28 November 2001 22:46

homer
Messages: 17
Registered: October 2001

Junior Member

What's the third day?
The third day in the month?
The third day after the creating of your table?
Tell me more.

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	write in a file in a distant computer
Next Topic:	precedure problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 01 17:45:29 CDT 2023