Re: DBMS_OBFUSCATION_TOOLKIT.des3decrypt???

Rick:

That was what I was afraid of! Thanks for the answer...

Regards,
Dave

Rick Wessman <rwessman_at_rochester.rr.com> wrote in message news:soc3dchn3qo.fsf_at_rwessman-pc.us.oracle.com...
> Hi, Dave:
>
> The procedure creates its own IV and key so I doubt that what you want to
 do
> will work. If you can use the encrypt procedure when inserting the data,
 then
> you'll be able to get the right data back.
>
> Rick
>
>
> "David Sisk" <davesisk_at_ipass.net> writes:
>
> > 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
> >
> >
> >
>
> --
> Rick Wessman
> Server Security Group
> Oracle Corporation
> Rick.Wessman_at_oracle.com
>
> The opinions expressed above are mine and do not necessarily reflect
> those of Oracle Corporation.
Received on Tue Mar 13 2001 - 20:04:49 CST