Cifrar MD5 crear funcion
SQLPLUS>
sql>@/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/prvtobtk.plb
sql>@/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/dbmsobtk.sql
Grant execute on dbms_crypto to public;
Grant execute on dbms_sqlhash to public;
Grant execute on dbms_obfuscation_toolkit to public;
Grant execute on dbms_obfuscation_toolkit_ffi to public;
Grant execute on dbms_crypto_ffi to public;
select md5('Hola mundo') from dual;
select md5('Hola mundo') from dual;
CREATE OR REPLACE FUNCTION SYSTEM.md5 (str IN VARCHAR2)
RETURN VARCHAR2
IS v_checksum VARCHAR2(32);
BEGIN
v_checksum := LOWER( RAWTOHEX( UTL_RAW.CAST_TO_RAW( sys.dbms_obfuscation_toolkit.md5(input_string => str) ) ) );
RETURN v_checksum;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END md5;
O TAMBIEN
create or replace function SYSTEM.md5 ( input varchar2 ) return sys.dbms_obfuscation_toolkit.varchar2_checksum as
begin
return sys.dbms_obfuscation_toolkit.md5( input_string => input );
end;