1 PACKAGE DBMS_SQLHASH AUTHID CURRENT_USER AS
2
3 FUNCTION gethash(sqltext IN varchar2, -- input sql statement
4 digest_type IN BINARY_INTEGER, -- digest algorithm type
5 chunk_size IN number DEFAULT 134217728) -- 128M
6 RETURN raw;
7
8 END DBMS_SQLHASH;