Describe package fails with ORA-04043
On 11.1.0.7, Linux x86-64
Please check the following scenario
SQL> @prvtclkm.plb
Package created.
Library created.
Package body created.
SQL> describe dbms_internal_clkm;
PROCEDURE GET_KEY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CLIENT VARCHAR2 IN
MASTER_KEY_ID VARCHAR2 IN
WRAPPED_KEY VARCHAR2 IN
FLAGS BINARY_INTEGER IN
KEY VARCHAR2 OUT
SQL> describe sys.dbms_internal_clkm;
ERROR:
ORA-04043: object sys.dbms_internal_clkm does not exist
SQL> grant execute on dbms_internal_clkm to gguser;
Grant succeeded.
SQL> grant execute on sys.dbms_internal_clkm to gguser;
grant execute on sys.dbms_internal_clkm to gguser
Please check the following scenario
SQL> @prvtclkm.plb
Package created.
Library created.
Package body created.
SQL> describe dbms_internal_clkm;
PROCEDURE GET_KEY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CLIENT VARCHAR2 IN
MASTER_KEY_ID VARCHAR2 IN
WRAPPED_KEY VARCHAR2 IN
FLAGS BINARY_INTEGER IN
KEY VARCHAR2 OUT
SQL> describe sys.dbms_internal_clkm;
ERROR:
ORA-04043: object sys.dbms_internal_clkm does not exist
SQL> grant execute on dbms_internal_clkm to gguser;
Grant succeeded.
SQL> grant execute on sys.dbms_internal_clkm to gguser;
grant execute on sys.dbms_internal_clkm to gguser
0