Hi all,
I can execute sys.dbms_crypto - but can't execute dbms_crypto without schema name.
Example:
select rawtohex(sys.dbms_crypto.hash(utl_raw.cast_to_raw(UPPER('LUCKY10')), 2)) as md5_64_pw from dual
does work
select rawtohex(dbms_crypto.hash(utl_raw.cast_to_raw(UPPER('LUCKY10')), 2)) as md5_64_pw from dual
doesn't work
How do I solve it?
Public synonym does exist:
select * from all_synonyms where synonym_name = 'DBMS_CRYPTO' and owner = 'PUBLIC'
PUBLIC DBMS_CRYPTO SYS DBMS_CRYPTO
select * from v$version
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production