Re: Delay or Wait function call in PL/SQL

Hi,
to wait 5 seconde.
Used

begin

        dbms_pipe.received_message('Pipe_not_exists',5) exception when others then null ;

This will wait 5 secondes for reading from a pipe which never exists.

-- 
Regards LANGE Francois.
flange_at_pt.lu
29A Route du vin.
L5450 Stadtbredimus.
Grand Duchy Of Luxembourg.
TEL (int) 352 697412.(*)
CEL(int) 352 021193652(*)
Phone numbers are variable length in Luxembourg.
Grand Duchy Of Luxembourg is a small country 80 miles on 60 miles between
France,Germany and Belgium.

Kelvin Ng <kingmang_at_hk.super.net> wrote in article
<35D1BF86.35C89B71_at_hk.super.net>...


> 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

> =============================================================

> 

> 

>