If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Hi,
I want to encrypt the 'password' and store it in the database and decrypt it on a 'later' date.

I am using the dbms_obfuscation_toolkit package as suggested by oracle.
Problem is, when I use the dbms_obfuccation package, the data will be converted to raw and then encrypted and stored again in the raw variable. For the display purpose we convert the raw variable using - rawtohex .

Now, I want to just encrypt the data and store in the table.

1) what should be the column type for storing this encryted password .

2)Can I store the encrypted data in the varchar2 datatype column and if so how do I decrypt this data later.