DBMS_OBFUSCATION_TOOLKIT.des3decrypt???

Hi:

We are loading data into Oracle8.1.7 that has been encrypted with a triple DES dll. I'm trying to use Oracle dbms_obfuscation_toolkit.des3decrypt proc to unencrypt the data as needed (leaving it stored encrypted). I'm not getting the same answer as the original data! The DLL we are using takes for key parms, an initialization vector and 3 cipher keys, however, des3decrypt proc only accepts a single encryption key string. I've tried concating the 4 pieces together in every possible combination, and I still don't get the original data back.

1. Has anyone else used this supplied package, and encountered similar difficulties? Did you find any work-around?
2. Has anyone found a vendor who provides a 3DES shared object for Solaris that is suitable as an external routine (ie. wrap a PL/SQL routine around it, so that it can be called from inside Oracle).
3. Is there a 3DES decryption class in the Java components built-into the database (or an external class that can be wrapped with PL/SQL or loaded into the database) that anyone knows anything about?

Any help greatly appreciated! Please post or email.

Regards,
Dave Received on Mon Mar 12 2001 - 18:54:35 CST