PLSQL - Procedure to Encrypt Password

Question

PLSQL - Procedure to Encrypt Password

Navigation

#1 by (1 votes)

-1

I searched the internet for a procedure to encrypt users password , however I only found functions .

Is there a way to generate a procedure to perform this process?

CREATE OR REPLACE FUNCTION MD5(VALOR VARCHAR) 
    RETURN VARCHAR2 
IS 
    V_INPUT VARCHAR2(2000) := VALOR; 
    HEXKEY  VARCHAR2(32)   := NULL; 
BEGIN 
    HEXKEY := RAWTOHEX(DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT => UTL_RAW.CAST_TO_RAW(V_INPUT))); 
    RETURN NVL(HEXKEY, ''); 
END;

oracle procedure pl-sql

asked by anonymous 27.09.2018 / 02:59

1 answer

Endpoint Rest with Jersey does not display expected result I need the commission to make the percentage, but the function only returns the value of the sale and also does not enter the criterion of if [closed]

score 1 · Accepted Answer

You can change the function and transform it into a procedure, but I recommend that you use the DBMS_CRYPTO package, it replaces the DBMS_OBFUSCATION_TOOLKIT and provides a more complete list of encryption algorithms.

One point of attention is that the DBMS_CRYPTO package does not work with VARCHAR2 directly, but it is possible to convert a VARCHAR2 to RAW using utl_i18n.string_to_raw.

I've set the example below, I hope it meets your need.

CREATE OR REPLACE PROCEDURE md5 (
   p_txt    IN VARCHAR2,
   p_hash   OUT VARCHAR2
) AS
   v_hash_raw   RAW(32);
BEGIN
   --Calcular o hash usando o algoritmo MD5
   v_hash_raw := dbms_crypto.hash(src => utl_i18n.string_to_raw(p_txt,'AL32UTF8'),
                                  typ => dbms_crypto.hash_md5);

   --Converter RAW para exadecimal
   p_hash := rawtohex(v_hash_raw);
END md5;