Re: Sleep in PL/SQL?

declare

   X integer;
begin

   .
   .
   .

• assume that X has been assigned a positive integer. dbms_lock.sleep(X); . . . end; /

Chuck Hamilton wrote:
>
> Is there any way to tell PL/SQL to sleep for X seconds before
> proceeding to the next line of code?
> --
> Chuck Hamilton
> chuckh_at_ix.netcom.com
>
> If at first you don't succeed, skydiving isn't for you.
 

-- 
_________________________________________________
Robert C. Nix
Oracle Tools Support
mailto:rnix_at_us.oracle.com

The thoughts, opinions, remarks, statements, ...
expressed here are my own and do not necessarily
represent those of Oracle Corporation.