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 -> Re: Timer Events - newbie question

Re: Timer Events - newbie question

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Wed, 05 Dec 2001 02:04:58 GMT
Message-ID: <ehfP7.6563$KY6.47042@rwcrnsc53>


You can use the dbms_job package to run a pl/sql program at intervals. Jim
"Luch" <optimaljedi_at_nospam.net> wrote in message news:wcfP7.28471$WC1.2987008_at_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 - 20:04:58 CST

Original text of this message

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