Re: Need to pause for 15 min in procedure....
From: Steve <stevemc_at_sierra.com>
Date: Mon, 19 Nov 2001 12:39:42 -0800
Message-ID: <9tbqi0$kpa$1_at_spiney.sierra.com>
Date: Mon, 19 Nov 2001 12:39:42 -0800
Message-ID: <9tbqi0$kpa$1_at_spiney.sierra.com>
[Quoted] 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 - 21:39:42 CET