Re: Urgent HELP, DBMS_LOCK

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