Home » SQL & PL/SQL » SQL & PL/SQL » About System triggers
About System triggers [message #35784] Mon, 15 October 2001 22:42 Go to next message
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

----------------------------------------------------------------------
Re: About System triggers [message #35786 is a reply to message #35784] Tue, 16 October 2001 00:54 Go to previous messageGo to next message
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

----------------------------------------------------------------------
Re: About System triggers [message #35833 is a reply to message #35784] Wed, 17 October 2001 14:38 Go to previous messageGo to next message
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

----------------------------------------------------------------------
Re: About System triggers [message #35971 is a reply to message #35784] Fri, 26 October 2001 12:25 Go to previous messageGo to next message
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?

----------------------------------------------------------------------
About System triggers [message #36454 is a reply to message #35786] Wed, 28 November 2001 21:57 Go to previous messageGo to next message
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

----------------------------------------------------------------------
Re: About System triggers [message #36457 is a reply to message #35786] Wed, 28 November 2001 22:46 Go to previous message
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.

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


Current Time: Thu Mar 28 08:51:45 CDT 2024