Re: "SLEEP" command in PL/SQL?

On Fri, 01 May 1998 16:19:46 GMT, weaver_at_pwrh.com (Walt Weaver) wrote:

>Does anyone know if there's an equivalent of the unix "sleep" command
>in PL/SQL? I've got a stored procedure that goes into a loop and
>inserts a specified number of rows into a table. I'd like to have the
>procedure insert a row every, say, three seconds. Is there a
>relatively easy way to this?

[...]

Hi Walt,

try sys.dbms_lock.sleep(no_of_seconds).

HTH
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Fri May 01 1998 - 13:56:02 CDT