Re: how can i program 'Timer' with PL/SQL ?

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Thu, 27 May 1999 09:52:41 +0100
Message-ID: <7iitke$282$1@news.inet.tele.dk>

You can wait for a given number of seconds (even 1/100s of a second) with DBMS_LOCK.SLEEP(x). The call is blocked for that period of time. You will need the EXECUTE_CATALOG_ROLE enabled in order to call DBMS_LOCK.

If you want to schedule an event to be executed later you can do that with the job scheduling facilitites in DBMS_JOB.

HTH. Finn

Wassim <net2000_at_francemel.com> wrote in message news:7ihvqn$j1k$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 - 03:52:41 CDT