Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
on May 10, 2012 11:46 AM by Mark Striekwold
Help using Dbms_Obfuscation_Toolkit
May 10, 2012 11:15 AM
Im facing below issue.
Parent DB (P1)
- version +'Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit'+
Child DB (C1, C2, C3)
C1 , C2 - version +'Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit'+
C3 - version +'Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit'+
Col1@TableP1 in P1 has a encrypted data. It is encrypted using Dbms_Obfuscation_Toolkit.DESENCRYPT tool.
The encrypted data in Col1@TableP1 is then sent to Col1@TableC1 , Col1@TableC2, Col1@TableC3 .
We are able to invoke the Dbms_Obfuscation_Toolkit.DESDECRYPT api to get the correct data in DBs C1 and C2.
Incase of DB C3, Dbms_Obfuscation_Toolkit.DESDECRYPT gives ORA-28232: invalid input length for obfuscation toolkit error.
We confirmed that the length of the encrypted data in DB C3 is in the multiple of 8 ( in this case 16).
The only difference we could notice is : the data is encrypted in the higher oracle version (DB P1) and decryption is tried from lower version (C3)
Could you please provide some suggestion on this issue.
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: Help using Dbms_Obfuscation_Toolkit
May 10, 2012 11:46 AM
in response to
Wrong forum. Please find a forum under the Oracle Database section https://forums.oracle.com/forums/category.jspa?categoryID=18 Can't tell you which will fit the best.