OraFAQ Forum: SQL & PL/SQL » Fire triggers on time events

Home » SQL & PL/SQL » SQL & PL/SQL » Fire triggers on time events

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

Fire triggers on time events [message #36220]

Mon, 12 November 2001 05:07

Daniel Martin
Messages: 1
Registered: November 2001

Junior Member

Hi,
I'd like to know if a trigger can be fired with time events. In other words, if I can specify to fire a trigger at 14:22pm, or 9:00 am, etc. or they are only DML or Database triggers.

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

Report message to a moderator

Re: Fire triggers on time events [message #36232 is a reply to message #36220]

Mon, 12 November 2001 09:53

andrew again
Messages: 2577
Registered: March 2000

Senior Member

stick the code into a procedure, then schedule the proc to run using dbms_job. Timing is not exact (down to seconds) but see the folloing link if you want exact timing.
http://asktom.oracle.com/pls/ask/f?p=4950:8:81472::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1253700499661,

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

Report message to a moderator

Previous Topic:	Re: Need help with to_date() function, thanks!
Next Topic:	Re: How to Retrieve CLOB withADODB Command Parameter...?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 30 17:29:31 CDT 2026