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

Hello Ron, the export is directly in the Oracle tables, there is no file to check. I tried the DBMS_LOCK.SLEEP. It works well in SQL but it gives compile errors when placed in a stored procedure. Any ideas?

Thanks for your help,
Moises

Ron Reidy wrote:
>
> Mendoza Family wrote:
> >
> > 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
> I assume this is on a Windows platform...if not, ignore what comes netx.
>
> On Windows, there is a Perl module, Win32::AdvNotify that watches files
> for certain events (like time stamp changes, file size changes, etc.).
> While this module is waiting for an event like this to occur, there are
> virtually no resources used (i.e. the CPU does not get spun while
> waiting).
>
> Maybe you could tailor this to your needs? If not, look at DBMS_LOCK
> for the sleep procedure.
> --
> Ron Reidy
> Oracle DBA
> Reidy Consulting, L.L.C.
Received on Tue Nov 20 2001 - 09:50:31 CST