Oracle: checksum function for strings

[cc lang=”plsql”]
CREATE OR REPLACE FUNCTION get_checksum(source_string IN VARCHAR)
RETURN VARCHAR IS
raw_string RAW(2048);
result RAW(2048);
BEGIN
raw_string := utl_i18n.string_to_raw(source_string);
result := sys.dbms_crypto.hash(raw_string, sys.dbms_crypto.hash_sh1);
RETURN result ;
END;
/
[/cc]

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.