Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Urgent HELP, DBMS_LOCK

Re: Urgent HELP, DBMS_LOCK

From: Stefan Fallet <sfallet_at_fallet.com>
Date: Mon, 25 Jan 1999 21:42:04 +0100
Message-ID: <36ACD71B.50C489FF@fallet.com>


Hi Perry,

connect as sys and do a grant execute:

grant execute on dbms_lock to dba;

hope this helps.

Stefan

Perry Cheng wrote:

> Hi netters,
> I have a problem on Oracle. I set up a new database and have some
> packages compiled. In one of the package I used SLEEP in DBMS_LOCK
> and gives me compile error.
> The line I write is:
> DBMS_LOCK.SLEEP(120)
> and error I got is something like :
> SYS.DBMS_LOCK needed to be declared
>
> The owner of the DBMS_LOCK of course is sys and the owner for the
> package is a dba. What went wrong exactly? Please help 'cause this
> is urgent.
>
> Thanks.
>
> -perry
Received on Mon Jan 25 1999 - 14:42:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US