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>
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:
Post a Comment