Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hashing a string

BluShadowDec 12 2005 — edited Dec 13 2005
Using Oracle 10g R2.
I want to hash a string using SHA-1 and the documentation that comes with 10g R2 talks about using the DBMS_CRYPTO package. It apparently has a nice little Hash function where you pass it your string and the type of crypto you want to use.

Unfortunately there isn't a DBMS_CRYPTO package.
There is however a DBMS_CRYPTO_TOOLKIT package which also has a Hash function in it, but this seems to take a few more parameters including "Persona"'s etc. and there's no documentation on this package included in the Oracle documentation.

All I want to do is generate a SHA-1 hash value for a string.
Can anyone give me any pointers please.

Cheers
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 10 2006
Added on Dec 12 2005
8 comments
13,135 views