Re: Unable to execute dbms_lock.sleep()

Hi Anurag,

While a specific error message other than 'can't compile' would have helped more, the most likely cause is either a missing grant execute to public or a missing public synonym. There are one or two packages which need to be granted manually in a Designer/2000 install, dbms_lock is one of them. For some reason they haven't been in included in the normal installation procedures.

Hth,

Sybrand Bakker, Oracle DBA

Anurag Minocha <anurag_at_synergy-infotech.com> wrote in message news:37ABDBB3.1ACD705_at_synergy-infotech.com...
> Hi,
> I am unable to compile a stored procedure in schema other than sys's
> which has the following statement
>
> dbms_lock.sleep(100);
>
> But from the sqlplus i am able to execute the follwing command in any
> schema.
>
> exec dbms_lock.sleep(100);
>
> What might be the problem. I have to use the sleep function in one of
> the stored procedures under the user which has resource,connect and dba
> roles.
>
> Thanks
> anurag
>
> also reply to
> anurag_at_synergy-infotech.com
>
>
>
>
Received on Sat Aug 07 1999 - 03:12:51 CDT