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

[Quoted] 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 - 16:48:54 CET