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 Mon Nov 19 2001 - 14:39:42 CST
