Re: md5 in Oracle 8i (its in the obfuscation package for 9i)

I thought that my memory wasn't failing me. :-)

MD5 is indeed available in 8i.

                                  Rick

In article <oSyB8.13619$M7.6024722_at_twister.socal.rr.com>, Richard says...
>
>I see md5 in dbms_obfuscation_toolkit under 8.1.7.2.0. Did you do a
>describe on the package? I see the following entries in the
>dbmsobtk.sql script...
>
>Rem rwessman 12/15/99 - Added a VARCHAR2 version of the MD5
>routines
>Rem rwessman 12/03/99 - Added MD5 procedure
>
>
>Richard
>
>Lee wrote:
>>
>> Two questions:
>> 1. Where can I get a pl/sql md5 routine
>> I'm running Oracle 8,1.7 As far as I can see it isnt till oracle 9
>> that the DBMS_OBFUSCATION_TOOLKIT has the md5 procedure (just has des
>> encrypt and decrypt).
>> I thought I saw a third party md5 pl/sql procedure somewhere Oh yeah,
>> plnet. I think it was,....is that my only option or is theresomething
>> "official" we can get?
>>
>> I suppose I could find a java class, load it via loadjava and then
>> write a pl/sql wrapper....just wondering how much of that;s already
>> been done,"free" for the download.
>>
>> 2. Once I do get an md5 routine I'll want to run it vs an operating
>> ssytem file that I've read into a LOB (well, CLOB file, actually).
>> What do people do about the possibility that there might be leading
>> and trailing blanks in the operating system file, or even an extra
>> cr/lf or some such? I see theres a dbms_lob.trim() but it doesn do
>> what Ltrim or Rtrim does, i.e. it doesnt trim off leading or trailing
>> blanks, it just chops the lob down to the size you specify. Funny
>> name for that, why not have called it "chop" ? Oh well.
>> Any thoughts?
>

                                Rick Wessman
                                Oracle Corporation

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.