issue with encrypt and decrypt
We faced an issue with the encrypt and deencrypt with the obfuscate package.
The situation is like this:
prod database is 220.127.116.11, the dev is 18.104.22.168
both of them are al32utf8.
the nls_lang in both servers are set to al32utf8.
we took a export from the prod and import into the dev.
there are some columns like ssn and credit card number in one table
cannot be deencrypted correctly in the dev. but they function very well in prod. we got the errors:
ORA-28232: invalid input length for obfuscation toolkit
BTW,most of rows can be deencrpted correctly.
Only a small portion of rows cannot.
SQL> select 'ODDW',t.act_cd, dump(t.act_cd) from exam_person t where t.exam_person_id = 17973529;
Typ=1 Len=15: 10,11,111,91,126,79,30,178,106,52,0,76,137,203,105
Typ=1 Len=16: 10,11,111,91,126,79,30,178,106,52,0,76,137,203,105,240
it looks like in the dev, the last 240 got cut off.
We checked the export and import, The logs show they are done
in al32utf8 character set.
Any idea about this?
Last edited by Lily_Liu_2004; 02-02-2006 at 11:45 AM.
the dmp file's head:
$ cat erst_data_Jan23a2006 | od -x | head
0000000 3000 2e00 0000 0000 0000 0000 0000 0000
0000020 0007 2e2e 0000 0000 0000 0000 0000 0000
0000040 3002 6578 706f 7274 5f73 746f 7265 5f64
how to interpret from this to know the exact character set fro this dmp file?
Anyone can help with this? Thanks.
Isn't it a good idea to have same Oracle release of dev and prod particularly when you try to implement some complex algorithm?
Downgrade your dev env to 22.214.171.124
Upgrade your prod to 126.96.36.199
Click Here to Expand Forum to Full Width