Thursday, February 2, 2017

Error message is PLS-00201: identifier 'DBMS_CRYPTO' must be declared

The issue is unable to compile the function used for cryptography and getting error

SQL> alter FUNCTION user1.mycryp compile;

Warning: Function altered with compilation errors.

SQL>

Error message is PLS-00201: identifier 'DBMS_CRYPTO' must be declared.


Solution:

Simple grant execute on sys.DBMS_CRYPTO to user1 by

SQL> grant execute on sys.DBMS_CRYPTO to user1;

Grant succeeded.

SQL>


Done!!!

SQL> alter FUNCTION  user1.mycryp compile;

Function altered.

SQL>

No comments: