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
