Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!nycmny1-snh1.gtei.net!news.gtei.net!panix!not-for-mail From: Lee Newsgroups: comp.databases.oracle.server Subject: md5 in Oracle 8i (its in the obfuscation package for 9i) Date: Sun, 05 May 2002 20:22:37 -0400 Organization: PANIX Public Access Internet and UNIX, NYC Lines: 26 Message-ID: <32jbdu4dmd82fqrn1c3e0vu1g4k26pc08a@4ax.com> NNTP-Posting-Host: pool-151-202-103-145.ny5030.east.verizon.net Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: reader1.panix.com 1020644503 18861 151.202.103.145 (6 May 2002 00:21:43 GMT) X-Complaints-To: abuse@panix.com NNTP-Posting-Date: Mon, 6 May 2002 00:21:43 +0000 (UTC) X-Newsreader: Forte Agent 1.8/32.553 Xref: easynews comp.databases.oracle.server:145981 X-Received-Date: Sun, 05 May 2002 17:21:22 MST (news.easynews.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?