How to Create an MD5 Hash?

[Glowball]

I've tried a few of the examples I've found on the Internet but I can't seem to find something that will return a 32-byte hex hash of a string in an Oracle query. I'm on 10g. Any ideas? I'm looking for something like the MD5() function in MySQL. Thanks!

 

[lecorr]

Did you look to DBMS_CRYPTO.HASH_MD5?

Follow this link to some reference to Crypto on Oracle:

http://www.psoug.org/reference/dbms_crypto.html

Hope that helps.

Christian

 

[Glowball]

I did it a stupid way in order to let ColdFusion create the hash instead, just to get the project finished. I tried dbms_crypto.hash_md5 along with some others and nothing was installed, or I don't have permissions. Either way, I found a workaround. Thanks!