Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Timer Events - newbie question

Timer Events - newbie question

From: Luch <optimaljedi_at_nospam.net>
Date: Wed, 05 Dec 2001 01:59:56 GMT
Message-ID: <wcfP7.28471$WC1.2987008@newsread2.prod.itd.earthlink.net>


I'd like to have a PL/SQL stored procedure on a timed event. Nothing fancy, something like

my_proc {
do stuff
timer (500 seconds)
}

timer {
post event my_proc()
}

Can anyone point me in the right direction to get me started. What I'm particularly not sure of is how to make it so the Procedure calls itself to start off whenever the database is restarted, and the correct way to use a timer with PL/SQL

--
Luch
replace nospam with usa for e-mail.
Received on Tue Dec 04 2001 - 19:59:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US