Search Tech Sites:

Oracle DBMS_OBFUSCATION_TOOLKIT »

Oracle – DBMS_OBFUSCATION_TOOLKIT: This package allows us to encrypt and decrypt values.
Here is an example on how to use the package:
—————————————————————-
FUNCTION encryptField(pi_fieldIn VARCHAR2)
RETURN RAW
IS

– 1. The input string has to be a multiple of 8 bytes…so RPAD it.
– 2. Convert VARCHAR2 to RAW to overcome DB Character Set dependencies (Useful when we are doing IMP and EXP to different
– character sets).

inputString varchar2(32767) := UTL_RAW.CAST_TO_RAW(rpad( pi_fieldIn, ceil(length(pi_fieldIn)/8)*8 , chr(0) ));
po_encrypted_string RAW(32767);

BEGIN

dbms_obfuscation_toolkit.DESEncrypt( INPUT =>inputString,
KEY => UTL_RAW.CAST_TO_RAW(‘XpVVze3F’),
ENCRYPTED_DATA => po_encrypted_string);
RETURN po_encrypted_string;
END encryptField;
————————————————————————————————–
– decryptField: Decrypts the parameter passed in and returns the decrypted string
—————————————————————————————————
FUNCTION decryptField(pi_fieldIn VARCHAR2)
RETURN RAW
IS
inputString varchar2(255) := pi_fieldIn;
po_decrypted_string RAW(32767);

BEGIN

dbms_obfuscation_toolkit.DESDecrypt( INPUT =>inputString,
KEY => UTL_RAW.CAST_TO_RAW(‘XpVVze3F’),
DECRYPTED_DATA => po_decrypted_string);

RETURN po_decrypted_string;
END decryptField;
——————————————————————————