hi,
Clay is right!
I can understand why you are having problems doing it in Oracle itself.
Below a small example for you:
=========================================================================
yd@MYDB.MU> r
1 create or replace function crypt( p_str in varchar2 ) return raw
2 as
3 l_data varchar2(255);
4 begin
5 l_data := rpad( p_str, (trunc(length(p_str)/8)+1)*8, chr(0) );
6 return dbms_obfuscation_toolkit.DESEncrypt( input => utl_raw.cast_to_raw(l_data),key => utl_raw.cast_to_raw('MagicKey') );
7* end;
Function created.
Elapsed: 00:00:00.19
yd@MYDB.MU> r
1 create or replace function decrypt( p_str in raw ) return varchar2
2 as
3 begin
4 return utl_raw.cast_to_varchar2( dbms_obfuscation_toolkit.DESdecrypt( input => p_str,key=> utl_raw.cast_to_raw('MagicKey') ) );
5* end;
Function created.
Elapsed: 00:00:00.03
yd@MYDB.MU>
yd@MYDB.MU> column data format a10
yd@MYDB.MU> create table tabyd ( data varchar2(9), data_enc raw(16) );
Table created.
Elapsed: 00:00:00.02
yd@MYDB.MU> insert into tabyd values ( '012345678',crypt('012345678'));
1 row created.
Elapsed: 00:00:00.04
yd@MYDB.MU> commit;
Commit complete.
Elapsed: 00:00:00.01
yd@MYDB.MU> select data,data_enc,decrypt(data_enc) data from tabyd;
DATA DATA_ENC DATA
__________ ________________________________ __________
012345678 07CF8213EDC46C277C720164D915B70C 012345678
Elapsed: 00:00:00.01
yd@MYDB.MU>
==============================================================================================
Hope this helps!
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
