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

This is most likely because you were granted EXECUTE on DBMS_LOCK through a role. Sign on as SYS and grante EXECUTE on DBMS_SLEEP to the procedure owner directly. If that was not the problem, post your errors.

HTH,
Brian

Mendoza Family wrote:
>
> 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 - 12:33:19 CST