DBMS_LOCK.SLEEP accessed by role during new package compilation
434126Dec 6 2004 — edited Apr 19 2005Hi,
I heard that oracle has a problem with new package compilation if user do not have a direct access to the sys package.
I have created my package which uses DBMS_LOCK.SLEEP. However I do not have a direct grant for this package. I have grant to the role A which has grant to role B which has grant to DBMS_LOCK package. During compilation I have :
PLS-00201: identifier 'DBMS_LOCK' must be declared.
When I try to use it directly from sql window it works without any problems:
begin
dbms_lock.sleep(5);
end;
/
Can somebody explain what is the problem ?
Thanks
Jaroslaw