Skip to Main Content

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!

Saving a hash value in the database

Javier PJan 2 2024

Hi All,

In Apex 23.2

I have a page item where I ask for an email password.

The type of the page item is Password so the entered text is hidden.
How can I save the hashed text into the database when saving the record using APEX_UTIL.HASH_SH256(l_input_text)?
How do I change the entered text to a hash format before the saving occurs so the hashed value get saved into the database?

Am planning to use that password as parameter to call the UTL_SMTP package to send emails.
How do I unhash it or how would use it when calling the ULT_SMTP package?

Thanks for the help!
Javier

Comments
Post Details
Added on Jan 2 2024
14 comments
795 views