1 Reply Latest reply on May 10, 2012 11:46 AM by Mark Striekwold

    Help using Dbms_Obfuscation_Toolkit

    924279
      Hi,

      Im facing below issue.

      Parent DB (P1) - version +'Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit'+

      Child DB (C1, C2, C3)
      C1 , C2 - version +'Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit'+
      C3 - version +'Oracle Database 11g Enterprise Edition Release 11.1.0.7.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.

      Thanks,
      Agathya