Re: [8.1.7] Anyone using the DBMS_OBFUSCATION_TOOLKIT.MD5 function ?

Thomas Kyte <tkyte_at_us.oracle.com> wrote:
> o I wouldn't call it "crypt", its a digest. crypt implies decrypt and
> its not decryptable. its a one way digest

I'll keep this in mind, but was just a fast test, so I didn't care a lot about the function name.

> o i wouldn't substr the input string

The problem is that the string *must be* 32 char at max, and was also a (desperate) try to force the PL/SQL interpreter to pick the right function... it didn't worked anyway.

> You'll want to send in the user/password together so that different
> people using

Unfortunately I have to send only the password (I know that sucks, but this is the requirement).

> o you do not need to substr the return result. The digest is always a
> varchar2(16)

Well, by my test is returning a varchar2(4000)...

Thnks. Received on Mon Nov 19 2001 - 09:07:39 CST