MD5 is intended to be used as message digest (hence, the name, where 5 stands
for incarnation of the algorithm as far as I know). So you shouldn't bother with
trimming anything from the file before computing its digest if you are interested
in file content verification.
And here's a hint for you regarding the availability of MD5 in 8i: all Java classes
loaded into the database get their MD5 digests computed which then used for
verification. Which means there IS an implementation of MD5, at least in Java,
available in 8i, because it is used internally. Look for it in aurora.md5 package.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Lee" <lee_at_jamtoday.com> wrote in message news:32jbdu4dmd82fqrn1c3e0vu1g4k26pc08a_at_4ax.com...
> 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?
>
>
>
>
Received on Mon May 06 2002 - 06:52:53 CDT
