Re: can we program 'Timer' with PL/SQL ?

You may want to use DBMS_JOB to run the function say 5 mins after submitting the job?

Mark

Wassim wrote in message <7ihvac$ilc$1_at_nnrp1.deja.com>...
>Hi,
>im using OAS3.0 with Oracle8.0.3
>i've to program a fonction with pl/sql that trigger an action after a
>fixed period of time, to be clear it'll like that :
>i want to fix as TRUE a certain value of one column in my table, i want
>this value change to FALSE after 5 minutes let's say, without having to
>do nothing, just change to FALSE after that period of time.
>can i do that with *only* PL/SQL ?
>thanks for help.
>Wassim.
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Thu May 27 1999 - 05:40:58 CDT