APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Apex 22.1: ORA-00904: "DBMS_CRYPTO"."HASH": invalid identifier

SmithJohn45Oct 16 2022

DB 21c XE, Apex 22.1
please move to appropriate forum if i have posted in wrong.
want to use hashed password in app, have tried below code as MD5 is deprecated but its not working showing below error ( DBMS_CRYPTO.HASH invalid identifier ). how can be achieved it? please help.
note: for below code i referred to the topic:

<a href="https://community.oracle.com/tech/developers/discussion/comment/16822361#Comment_16822361" alt="undefined type="undefined">undefined</a> (0 Bytes)
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production


SQL> select dbms_crypto.hash(utl_raw.cast_to_raw('hshd1234#' || '1234567890ABCDXYZ'), 4 /* DBMS_CRYPTO.HASH_SH256 */) dmy
 2 from dual;
select dbms_crypto.hash(utl_raw.cast_to_raw('hshd1234#' || '1234567890ABCDXYZ'), 4 /* DBMS_CRYPTO.HASH_SH256 */) dmy
    *
ERROR at line 1:
ORA-00904: "DBMS_CRYPTO"."HASH": invalid identifier

regards

This post has been answered by fac586 on Oct 16 2022

Jump to Answer

Added on Oct 16 2022

#apex-discussions

2 comments

2,763 views

1 mention