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)
I am not able to understand the post.
ReplyDeletewhat 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
Hey Ram
ReplyDeleteCheck 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.
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