Search 800 + Posts

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