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

From: Paul Carpenter <pc69792_at_nospam.GlaxoWellcome.co.uk>
Date: 27 May 1999 07:52:15 GMT
Message-ID: <01bea815$be7f0e90$281ef091@ukd23068>

Wassim

The DBMS_LOCK.SLEEP function will allow PL/SQL code to lay dormant for a specified period of time.

Hope this helps

Paul Carpenter
Database Administrator - ICIS Group Finance IS 1st Floor Glaxo Wellcome House East, Greenford Tel: 0181 966 8074 (Internal: 711 8074)

Wassim <net2000_at_francemel.com> wrote in article <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 - 02:52:15 CDT