Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: May 10, 2012 6:46 AM by
Help using Dbms_Obfuscation_Toolkit
May 10, 2012 6:15 AM
Im facing below issue.
Parent DB (P1)
- version +'Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit'+
Child DB (C1, C2, C3)
C1 , C2 - version +'Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit'+
C3 - version +'Oracle Database 11g Enterprise Edition Release 126.96.36.199.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.
This content has been marked as final.
Show 1 reply
Re: Help using Dbms_Obfuscation_Toolkit
May 10, 2012 6: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.