How can md5 hash sum be calculated in Oracle 11g for text strings of 5000 or more characters?

Question

Oracle

Good afternoon, faced a problem when it is necessary to have a certain short unique identifier in length of a line in 11th .
Having searched the Internet, I found a solution with which you can get a hash ( DBMS_OBFUSCATION_TOOLKIT ), but there is a limitation that the input parameter is in varchar2 and is limited to 2000 characters

. How can I solve the problem for hashing longer strings?

Answer 1

split into chunks of 2000 take hash from hash of chunks)

Answer 2

https://docs.oracle.com/cd/B19306_01/java.102/b141... Here is an example of creating a java store.

Answer 3

STANDARD_HASH

The expr argument determines the data for which you want Oracle Database to compute a hash value. There are no restrictions on the length of data represented by expr, which commonly resolves to a column name. The expr cannot be a LONG or LOB type. It cannot be a user-defined object type. All other data types are supported for expr.