Re: Does Oracle Support MD5()

"Geoff Muldoon" <gmuldoon_at_nospam.scu.edu.au> wrote in message news:MPG.1cebef1e97ce01a59896b0_at_news.x-privat.org...
> postbus_at_sybrandb.demon.nl says...
>> On Wed, 11 May 2005 01:18:51 +0800, "ashley" <none_at_gmeail.com> wrote:
>>
>> >A username/password table. Both we dont want to keep password in
>> >plaintext.
>> >So it is better to keep the hashed (MD5) image. If you have used Tomcat
>> >web
>> >server, the JDBCRealm requires such a table with password MD5'ed.
>>
>> As to your question, there is a dbms_obfuscation package in Oracle
>> which allows you to encrypt any string.
>
> By any number of encryption methods including MD5.
>
> Specifically (after defining variables v_not_hashed and v_hashed):
> v_hashed := DBMS_OBFUSCATION_TOOLKIT.MD5(input_string => v_not_hashed);
>
> Geoff M

caveat: you must call the function with the named parameter convention, since it is overloaded to operate on raw as well as 'varchar2_checksum' datatypes

BTW -- varchar2_checksum appears to be just a documenter's documenter's unexplained shortcut to hint at the content of the parameter, it's not an actual datatype, as DBA_ARGUMENTS shows the INPUT_STRING parameter as type VARCHAR2, which indicates oracle's internal type '1'

++ mcs Received on Wed May 11 2005 - 06:43:58 CDT