Re: Where is MD5() FUNCTIONS

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Tue, 28 Jun 2005 10:50:39 +0200
Message-ID: <d9r30s$c1c$04$1@news.t-online.com>

Thomas schrieb:
> I was told that MD5 function is available in the DBMS_OBFUSCATION_TOOLKIT
> package. However, I looked up the Oracle9i Supplied PL/SQL Packages and
> Types Reference (R9.2) and there are only 4 DES/DES3 encryption/decrypt
> procedures - no md5.
>
> Does anybody know the exact location of MD5?
>
> Thx
>
>

Take a look into spec

SQL> desc dbms_obfuscation_toolkit
Element Type

-------------------- ---------
VARCHAR2_CHECKSUM    SUBTYPE
RAW_CHECKSUM         SUBTYPE
TWOKEYMODE           VARIABLE
THREEKEYMODE         VARIABLE
INVALIDTRIPLEDESMODE EXCEPTION
DESGETKEY            PROCEDURE
DES3GETKEY           PROCEDURE
DESENCRYPT           PROCEDURE
DESDECRYPT           PROCEDURE
DES3ENCRYPT          PROCEDURE
DES3DECRYPT          PROCEDURE
MD5                  PROCEDURE

SQL> Best regards

Maxim Received on Tue Jun 28 2005 - 03:50:39 CDT