Re: Sleep in PL/SQL?
Date: 1996/03/14
Message-ID: <4ia71f$d8m_at_gossamer.itmel.bhp.com.au>#1/1
In article <31485a70.3698155_at_nntp.ix.netcom.com>, chuckh_at_ix.netcom.com (Chuck Hamilton) says:
>
>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.
Not that I have been able to find explicitly, but you can fake it by putting in a for loop, which has nothing (except a Null) in it. Some experimentation would be necessary to do the timing. Actually, how about writing a procedure containig a while loop that checks sysdate constantly - high overhead, but would work...
If done inside Forms, then you could have a timer running for X seconds, and constantly check if it is still running (use find_timer)
I'm not aware of any built-in etc that will do it for you, and I have looked.
HIH
Lee
----------------+---------------------------------------------------
This | Lee Levy, ISSD Systems Development, Del Code (34)
space | BHP Information Technology, ACN 006 476 213
left blank | PO Box 261, Warrawong, NSW 2502, Australia
intentionally | PH: +61 42 75-5485 Fax: -5500 Tie: 8855-
in mourning | Internet : levy.lee.ls_at_bhp.com.au
----------------+---------------------------------------------------Opinions expressed are mostly my own, so give me some credit. Received on Thu Mar 14 1996 - 00:00:00 CET