Re: Where is MD5() FUNCTIONS

On Tue, 28 Jun 2005 11:28:23 -0700, DA Morgan <damorgan_at_psoug.org> wrote:

>>>>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?
>>>
>>>Take a look into spec
>>>
>>>MD5 PROCEDURE
>>
>> I dont understand why it is not explicitly documented. Is it a hidden
>> feature not formally supported?
>
>http://tahiti.oracle.com
>click on 9.2
>enter search criterion: "MD5"
>looks documented to me.

 Whilst there are references to it scattered across other manuals, the definitive guide for PL/SQL packages is supposed to be the Supplied PL/SQL Packages and Types Reference which omits the function in 9i.

http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_obtoo2.htm#10242

 Which would be why the OP is concerned it's undocumented.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool