Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delay or Wait function call in PL/SQL
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
![]() |
![]() |