Database Administration (MOSC)

MOSC Banner

Describe package fails with ORA-04043

edited Jul 27, 2011 11:59PM in Database Administration (MOSC) 8 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center