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 -> Re: adding delay/pause/sleep inside oracle stored procedure

Re: adding delay/pause/sleep inside oracle stored procedure

From: jobs <jobs_at_webdos.com>
Date: 10 Jan 2007 13:38:10 -0800
Message-ID: <1168465090.762411.322030@i56g2000hsf.googlegroups.com> 





Ed Prochak wrote:


> jobs wrote:

> > What's the best way to add a 500 second delay/pause/sleep inside an

> > oracle stored procedure?

>

> WHY?



Sorry for delayed response.  I'm building a workflow application  in
asp.net that will schedule, track and manage processes on various types
of rdbms. I just needed a stored procedure that would hang around for a
few minutes for testing and not cost the server any cpu.



it worked.. thanks.
Received on Wed Jan 10 2007 - 15:38:10 CST












Original text of this message













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