OraFAQ Forum: Server Administration » How to schedule a trigger

Home » RDBMS Server » Server Administration » How to schedule a trigger

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

How to schedule a trigger [message #211532]

Fri, 29 December 2006 04:24

sreehari
Messages: 101
Registered: May 2006

Senior Member

Hi

How to schedule a trigger, i need to fire the trigger every sunday.

Thanks

Report message to a moderator

Re: How to schedule a trigger [message #211545 is a reply to message #211532]

Fri, 29 December 2006 05:43

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It needs a triggering event to be fired. If you can schedule something (depending on kind of a trigger) to fire it, fine. If not, move trigger code to a PL/SQL procedure and schedule it (instead of a trigger).

Report message to a moderator

Re: How to schedule a trigger [message #211580 is a reply to message #211545]

Fri, 29 December 2006 11:42

andrew again
Messages: 2577
Registered: March 2000

Senior Member

http://www.orafaq.com/node/862

http://www.orafaq.com/node/871

Report message to a moderator

Previous Topic:	Cloning Schema
Next Topic:	10G OEM Java Console.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:26:54 CDT 2024