Jan 26, 2010

Oracle Utility to encrypt and decrypted data

Thanks to Robet for sharing the Oracle Utility to encrypt and decrypted.
Below is example to encrypt and decrypted.

declare
l_encrypted VARCHAR2(1000);
l_decrypted VARCHAR2(1000);
l_key VARCHAR2(20):='7777888855551111';
BEGIN
DBMS_OBFUSCATION_TOOLKIT.desencrypt(input => UTL_RAW.cast_to_raw('4505111111111331'),
KEY => l_key,
encrypted_data => l_encrypted);
dbms_output.put_line('l_encrypted = '||l_encrypted);
DBMS_OBFUSCATION_TOOLKIT.desdecrypt
(input=> l_encrypted,
KEY => l_key,
decrypted_data => l_decrypted);
dbms_output.put_line('l_decrypted = '||l_decrypted);
END;

that's for Now ( I am really busy, to do something with ADF Mobile)

3 comments:

  1. I am not able to understand the post.

    what is the original value.

    what is the encrypt value

    if i decript the same original value should come....

    am i right?

    update please....

    thanks
    ramkumar

    ReplyDelete
  2. Hey Ram

    Check my latest blog on encrypt and Decrypt.
    http://eoracleapps.blogspot.com/2010/01/encryption-and-decryption-utilities-in.html

    There I have explained with better example.

    these 2 blogs are to tell you about the API that offered by Oracle, and you are 100% correct about what we encrypt is whet we get after decryption.

    ReplyDelete
  3. Detailed post. I like your blog as I do find so many informative post that shares various features of Oracle. As I am a beginner I do find all of them very helpful to me. I have read the updated post also in which you have explained this utility using a nice example. Thanks.

    ReplyDelete