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!

hash password, dbms_obfuscation_toolkit.md5 and dbms_crypto

LemarMay 24 2023

Hello,

Oracle XE 21c, Apex 23.1

in Oracle xe 18c and earlier versions of Apex we used

l_password := utl_raw.cast_to_raw (
dbms_obfuscation_toolkit.md5(
input_string => p_password ||
substr(l_salt,4,14) ||
p_user_name ||
substr(l_salt,5,10)));

or

l_password := dbms_crypto.hash(
utl_i18n.string_to_raw(p_password || substr(l_salt,4,14) || p_user_name || substr(l_salt,5,10), 'AL32UTF8'),
dbms_crypto.hash_md5
);

what can we use instead in 21c and Apex 23.1?

Thanks,

Marc

Added on May 24 2023

4 comments

437 views