Re: How to delay the execution of an SQL statement?

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 02 May 2002 19:06:55 GMT
Message-ID: <3CD18E4E.35BE24BE@exesolutions.com>

FC wrote:

> "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3CD00A75.99B75BA1_at_exesolutions.com...
> > Ed Prochak wrote:
> >
> > > I'm always curious about this is a database context: Why do you want a
> > > delay?
> > > (I've done lots of real-time/embedded programming where this kind of
> > > thing is sometimes appropriate, but I don't know of any database reasons
> > > for this.)
> > >
> > > ed
> > >
> > > Anirban wrote:
> > > >
> > > > I want to delay the execution of an SQL statement in a PL/SQL block.
> > > > Is there any function like 'wait' or 'delay' which will delay the
> > > > query?
> > >
> > > --
> > > Edward J. Prochak --- Magic Interface, Ltd.
> > > Ofc: 440-498-3700
> > > on the web at --- http://www.magicinterface.com
> > > email: ed.prochak_at_magicinterface.com
> >
> > So that later on you can go back to the customer and charge thousands of
> > dollars to "tune" things and make them faster. (just kidding ... I think)
> >
> > Daniel Morgan
> >

> Well,
> I have a similar question, I'd like to make a stored procedure enter into a
> "stand-by" state without consuming too much CPU time.
> Say for instance I am looping waiting for a user triggered event, how can I
> doze for half a second and then wake up again ?

What are you going to do if the triggering event never happens?

Daniel Morgan Received on Thu May 02 2002 - 14:06:55 CDT