Skip to Main Content

SQL & PL/SQL

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!

decrypt character string

Tricampeon_1981Mar 19 2021

Hello friends, good night, I would like a little of your great wisdom I have a tremendous problem !!

Look I have a function that is perfect, what it does is encrypt a character string and it makes it perfect (here is the code)

My problem is that I don't have the reverse function, I need to decrypt the value, could you help me to get the reverse function? have the string of characters .. original

worked with oracle 12g

<code>
encxrip.PNGcreate or replace FUNCTION encriptarclave (pe_clavesinencriptar IN VARCHAR2)
RETURN VARCHAR2
IS
claveencriptada_ VARCHAR (32 );
BEGIN
claveencriptada_ :=
DBMS_OBFUSCATION_TOOLKIT.md5
(input => UTL_RAW .cast_to_raw
(UPPER (pe_clavesinencriptar)
)
);
RETURN claveencriptada_ ;
END;
</code>

This post has been answered by Paulzip on Mar 19 2021
Jump to Answer
Comments
Post Details
Added on Mar 19 2021
15 comments
703 views