During Clarity PPM upgrade, an Oracle error is thrown:
1/15/19 4:21 PM (ExecTask) com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-06550: line 11, column 20:
1/15/19 4:21 PM (ExecTask) PL/SQL: ORA-00904: "DBMS_OBFUSCATION_TOOLKIT"."MD5": invalid identifier
1/15/19 4:21 PM (ExecTask) ORA-06550: line 11, column 6:
1/15/19 4:21 PM (ExecTask) PL/SQL: SQL Statement ignored
1/15/19 4:21 PM (ExecTask)
Release: Any Clarity release with Oracle
select SUBSTR(dbms_obfuscation_toolkit.md5(input => UTL_RAW.cast_to_raw(to_char(sysdate,'YYYY-MM-DD HH24:MI:SS'))),-32,32) FROM dual;