Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Delay or Wait function call in PL/SQL

Re: Delay or Wait function call in PL/SQL

From: <sjakobson_at_my-dejanews.com>
Date: 1998/08/13
Message-ID: <6qvhfm$pqo$1@nnrp1.dejanews.com>#1/1

Use built-in procedure dbms_lock.sleep(sleep_time);

Solomon Yakobson.

In article <35D1BF86.35C89B71_at_hk.super.net>,   kelvinng_at_POBoxes.com wrote:
> Hello,
>
> Is there any way to call a delay or wait function call inside PL/SQL
> to make a procedure or function sleep await e.g. 5 sec before execute
> next statement.
>
> Kelvin Ng
>
> --
> =============================================================
> # Home Page : http://welcome.to/kelvinng
> # My PGP Public Key : http://www.hk.super.net/~kingmang/pgpkeys.html
> =============================================================
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 13 1998 - 00:00:00 CDT

Original text of this message

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