Re: Sleep in PL/SQL?

From: Andre Rusanoff <arusanoff_at_maxwell.attmail.com>
Date: 1996/03/14
Message-ID: <3148B71E.16D6_at_maxwell.attmail.com>#1/1


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.

If your PL/SQL is within Forms 4.5, you can use TIMER to do this.

If not, just enter a loop within your PL/SQL block and keep selecting to_char(sysdate,'SS') until the difference between first and last results is equal to X and then exit the loop.

AER. Received on Thu Mar 14 1996 - 00:00:00 CET

Original text of this message