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: Need to pause for 15 min in procedure....

Re: Need to pause for 15 min in procedure....

From: Mendoza Family <NetScans_at_ix.netcom.com>
Date: Tue, 20 Nov 2001 09:48:54 -0600
Message-ID: <3BFA7B66.BB43A8BC@ix.netcom.com>


Hello Steve, I tried that. It works well in SQL but it gives compile errors when placed in a stored procedure. Any ideas?

Thanks for your help,
Moises

Steve wrote:
>
> look into DBMS_LOCK.sleep
>
> "Mendoza Family" <NetScans_at_ix.netcom.com> wrote in message
> news:3BF9462F.A8C6F95_at_ix.netcom.com...
> > I have an external process that loads data into Oracle. After every
> > table it prompts for the password for the ODBC connection. I have a
> > process that checks the record counts and pages out after the record
> > count has stopped increasing. I would like to have it check every 15
> > minutes instead of looping for 15 minutes and wasting resources. Is
> > there any way to "pause" for x amount of minutes?
> >
> > Thanks for any help given,
> > Moises
Received on Tue Nov 20 2001 - 09:48:54 CST

Original text of this message

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