Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> "SLEEP" command in PL/SQL?

"SLEEP" command in PL/SQL?

From: Walt Weaver <weaver_at_pwrh.com>
Date: Fri, 01 May 1998 16:19:46 GMT
Message-ID: <3549f46e.13039409@usenet.vlt.com>


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?

I've already got a Korn shell script that loops and inserts a row every three seconds, but I'd like to do the whole thing in a stored procedure. Any ideas?

Thanks,
--Walt Weaver
  Powerhouse Technologies
  Bozeman, MT USA Received on Fri May 01 1998 - 11:19:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US