I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases.<\/p>\n
To check previous changes, follow the links below:<\/p>\n
So what oracle internal objects were changed in October 2019 – <\/strong>191016<\/strong><\/span>?<\/p>\n And created?<\/p>\n P.S: Nothing was added for 11.2 \/ 12.1 \/ 12.2 \/ 18\u00a0 in Oracle objects.<\/strong><\/span><\/p>\n So which are exactly the objects modified by 191016?<\/p>\n P.S:VERSION PATCH OWNER TYPE TOTAL\r\n---------- ---------- ------------------------------ --------------- ----------\r\n11.2.0.4 BP SYS PACKAGE BODY 1\r\n11.2.0.4 PSU SYS PACKAGE BODY 1\r\n12.1.0.2 BP SYS PACKAGE 2\r\n12.1.0.2 BP SYS PACKAGE BODY 9\r\n12.1.0.2 PSU DVSYS PACKAGE 1\r\n12.1.0.2 PSU DVSYS PACKAGE BODY 2\r\n12.1.0.2 PSU LBACSYS PACKAGE BODY 1\r\n12.1.0.2 PSU SYS PACKAGE 1\r\n12.1.0.2 PSU SYS PACKAGE BODY 1\r\n12.2.0.1 RU SYS PACKAGE 2\r\n12.2.0.1 RU SYS PACKAGE BODY 7\r\n12.2.0.1 RU SYS VIEW 1\r\n18.0.0.0 18.6RUR SYS PACKAGE 2\r\n18.0.0.0 18.6RUR SYS PACKAGE BODY 1\r\n18.0.0.0 18.7RUR SYS PACKAGE 2\r\n18.0.0.0 18.7RUR SYS PACKAGE BODY 1\r\n18.0.0.0 RU SYS PACKAGE 4\r\n18.0.0.0 RU SYS PACKAGE BODY 5\r\n18.0.0.0 RU XDB PACKAGE 1\r\n18.0.0.0 RU XDB PACKAGE BODY 1\r\n19.0.0.0 19.3RUR SYS PACKAGE 2\r\n19.0.0.0 19.3RUR SYS PACKAGE BODY 2\r\n19.0.0.0 19.4RUR SYS PACKAGE 2\r\n19.0.0.0 19.4RUR SYS PACKAGE BODY 1\r\n19.0.0.0 RU DVSYS PACKAGE 2\r\n19.0.0.0 RU DVSYS PACKAGE BODY 2\r\n19.0.0.0 RU MDSYS PACKAGE 7\r\n19.0.0.0 RU MDSYS PACKAGE BODY 7\r\n19.0.0.0 RU MDSYS TYPE BODY 1\r\n19.0.0.0 RU SYS PACKAGE 6\r\n19.0.0.0 RU SYS PACKAGE BODY 9\r\n19.0.0.0 RU SYS TYPE BODY 1\r\n19.0.0.0 RU SYS VIEW 1\r\n19.0.0.0 RU XDB PACKAGE 1\r\n19.0.0.0 RU XDB PACKAGE BODY 1<\/pre>\n
VERSION PATCH OWNER TYPE TOTAL\r\n---------- ---------- ------------------------------ --------------- ----------\r\n19.0.0.0 RU DVSYS VIEW 1<\/pre>\n
VERSION PATCH OWNER TYPE NAME ACTION\r\n---------- --------------- ------------------------------ --------------- ------------------------------ ------\r\n11.2.0.4 PSU & BP SYS PACKAGE BODY DBMS_RCVMAN MOD\r\n12.1.0.2 BP SYS PACKAGE PRVT_COMPRESSION MOD\r\n12.1.0.2 BP SYS PACKAGE BODY DBMS_QOPATCH MOD\r\n12.1.0.2 BP SYS PACKAGE BODY DBMS_SNAP_INTERNAL MOD\r\n12.1.0.2 BP SYS PACKAGE BODY DBMS_SQLPATCH MOD\r\n12.1.0.2 BP SYS PACKAGE BODY DBMS_STATS MOD\r\n12.1.0.2 BP SYS PACKAGE BODY DBMS_SYNC_REFRESH MOD\r\n12.1.0.2 BP SYS PACKAGE BODY DBMS_XSTREAM_ADM_INTERNAL MOD\r\n12.1.0.2 BP SYS PACKAGE BODY DBMS_XSTREAM_GG_INTERNAL MOD\r\n12.1.0.2 BP SYS PACKAGE BODY PRVT_COMPRESSION MOD\r\n12.1.0.2 PSU DVSYS PACKAGE DBMS_MACUTL MOD\r\n12.1.0.2 PSU DVSYS PACKAGE BODY DBMS_MACADM MOD\r\n12.1.0.2 PSU DVSYS PACKAGE BODY DBMS_MACUTL MOD\r\n12.1.0.2 PSU LBACSYS PACKAGE BODY OLS_ENFORCEMENT MOD\r\n12.1.0.2 PSU & BP SYS PACKAGE DBMS_RCVMAN MOD\r\n12.1.0.2 PSU & BP SYS PACKAGE BODY DBMS_RCVMAN MOD\r\n12.2.0.1 RU SYS PACKAGE DBMS_RCVMAN MOD\r\n12.2.0.1 RU SYS PACKAGE DBMS_REDEFINITION_INTERNAL MOD\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_HEAT_MAP_INTERNAL MOD\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_RCVMAN MOD\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_REDEFINITION MOD\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_REDEFINITION_INTERNAL MOD\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_STATS MOD\r\n12.2.0.1 RU SYS PACKAGE BODY DBMS_STATS_ADVISOR MOD\r\n12.2.0.1 RU SYS PACKAGE BODY PRVT_ILM MOD\r\n12.2.0.1 RU SYS VIEW DBA_APPLY_ERROR MOD\r\n18.0.0.0 RU SYS PACKAGE DBMS_RCVMAN MOD\r\n18.0.0.0 RU SYS PACKAGE DBMS_REDEFINITION_INTERNAL MOD\r\n18.0.0.0 RU SYS PACKAGE BODY DBMS_HEAT_MAP_INTERNAL MOD\r\n18.0.0.0 RU SYS PACKAGE BODY DBMS_REDEFINITION MOD\r\n18.0.0.0 RU SYS PACKAGE BODY DBMS_REDEFINITION_INTERNAL MOD\r\n18.0.0.0 RU SYS PACKAGE BODY PRVT_ILM MOD\r\n18.0.0.0 RU XDB PACKAGE DBMS_SODA_ADMIN MOD\r\n18.0.0.0 RU XDB PACKAGE BODY DBMS_SODA_ADMIN MOD\r\n18.0.0.0 RU & 18.7RUR & SYS PACKAGE DBMS_BACKUP_RESTORE MOD\r\n 18.6RUR\r\n18.0.0.0 RU & 18.7RUR & SYS PACKAGE DBMS_REGISTRY MOD\r\n 18.6RUR\r\n18.0.0.0 RU & 18.7RUR & SYS PACKAGE BODY DBMS_RCVMAN MOD\r\n 18.6RUR\r\n19.0.0.0 RU DVSYS VIEW DBA_DV_COMMON_OPERATION_STATUS NEW\r\n19.0.0.0 19.3RUR SYS PACKAGE BODY DBMS_DBFS_SFS MOD\r\n19.0.0.0 RU DVSYS PACKAGE DBMS_MACADM MOD\r\n19.0.0.0 RU DVSYS PACKAGE DBMS_MACUTL MOD\r\n19.0.0.0 RU DVSYS PACKAGE BODY DBMS_MACADM MOD\r\n19.0.0.0 RU DVSYS PACKAGE BODY DBMS_MACUTL MOD\r\n19.0.0.0 RU MDSYS PACKAGE RDF_APIS_INTERNAL MOD\r\n19.0.0.0 RU MDSYS PACKAGE SDO_SEM_INFERENCE MOD\r\n19.0.0.0 RU MDSYS PACKAGE SEM_RDFCTX MOD\r\n19.0.0.0 RU MDSYS PACKAGE SEM_RDFCTX_DR MOD\r\n19.0.0.0 RU MDSYS PACKAGE S_SDO_RDF_INFO MOD\r\n19.0.0.0 RU MDSYS PACKAGE S_SDO_RDF_INTERNAL MOD\r\n19.0.0.0 RU MDSYS PACKAGE S_SDO_RDF_QUERY MOD\r\n19.0.0.0 RU MDSYS PACKAGE BODY RDF_APIS_INTERNAL MOD\r\n19.0.0.0 RU MDSYS PACKAGE BODY SDO_RDF MOD\r\n19.0.0.0 RU MDSYS PACKAGE BODY SDO_RDF_INTERNAL MOD\r\n19.0.0.0 RU MDSYS PACKAGE BODY SDO_SEM_INFERENCE MOD\r\n19.0.0.0 RU MDSYS PACKAGE BODY SDO_SEM_INF_INTERNAL MOD\r\n19.0.0.0 RU MDSYS PACKAGE BODY SEM_RDFCTX_DR MOD\r\n19.0.0.0 RU MDSYS PACKAGE BODY S_SDO_RDF_INTERNAL MOD\r\n19.0.0.0 RU MDSYS TYPE BODY SEMCONTEXTINDEXMETHODS MOD\r\n19.0.0.0 RU SYS PACKAGE DBMS_ASH MOD\r\n19.0.0.0 RU SYS PACKAGE PRVT_ASH_OMX MOD\r\n19.0.0.0 RU SYS PACKAGE SDO_RDF_EXP_IMP MOD\r\n19.0.0.0 RU SYS PACKAGE SDO_RDF_SYS MOD\r\n19.0.0.0 RU SYS PACKAGE BODY DBMS_AQ_INV MOD\r\n19.0.0.0 RU SYS PACKAGE BODY DBMS_ASH MOD\r\n19.0.0.0 RU SYS PACKAGE BODY DBMS_ASH_INTERNAL MOD\r\n19.0.0.0 RU SYS PACKAGE BODY DBMS_AUTO_INDEX_INTERNAL MOD\r\n19.0.0.0 RU SYS PACKAGE BODY DBMS_HEAT_MAP_INTERNAL MOD\r\n19.0.0.0 RU SYS PACKAGE BODY DBMS_SCHEDULER MOD\r\n19.0.0.0 RU SYS PACKAGE BODY PRVT_ASH_OMX MOD\r\n19.0.0.0 RU SYS PACKAGE BODY PRVT_ILM MOD\r\n19.0.0.0 RU SYS TYPE BODY WRI$_REPT_ASH_OMX MOD\r\n19.0.0.0 RU SYS VIEW DBA_AUTO_INDEX_EXECUTIONS MOD\r\n19.0.0.0 RU XDB PACKAGE DBMS_SODA_ADMIN MOD\r\n19.0.0.0 RU XDB PACKAGE BODY DBMS_SODA_ADMIN MOD\r\n19.0.0.0 RU & 19.4RUR & SYS PACKAGE DBMS_BACKUP_RESTORE MOD\r\n 19.3RUR\r\n19.0.0.0 RU & 19.4RUR & SYS PACKAGE DBMS_REGISTRY MOD\r\n 19.3RUR\r\n19.0.0.0 RU & 19.4RUR & SYS PACKAGE BODY DBMS_RCVMAN MOD\r\n 19.3RUR<\/pre>\n
What changed for each? (click to see the changes)<\/strong><\/h2>\n
\n
\n
\n
\n
\n
\n
Changed Objects<\/h2>\n
\n<\/strong><\/span>> = Added Lines
\n< = Removed Lines<\/strong><\/span><\/p>\n11.2.0.4<\/strong><\/h3>\n
563c563\r\n< NULL COMPLETION_TIME,\r\n---\r\n> BDF.COMPLETION_TIME COMPLETION_TIME,\r\n<\/pre>\n
563c563\r\n< NULL COMPLETION_TIME,\r\n---\r\n> BDF.COMPLETION_TIME COMPLETION_TIME,\r\n<\/pre>\n
12.1.0.2<\/strong><\/h3>\n
463a464,472\r\n> \/**\r\n> * Checks whether the given role is enabled in the current session.\r\n> *\r\n> * @param p_role Role to check\r\n> * @return TRUE if the role is enabled in the current session\r\n> *\/\r\n> FUNCTION session_enabled_role(p_role IN VARCHAR2)\r\n> RETURN BOOLEAN;\r\n> \r\n497a507,515\r\n> \r\n> \/**\r\n> * Checks whether the given role is enabled in the current session.\r\n> *\r\n> * @param p_role Role to check\r\n> * @return Y if the role is enabled in the current session, N otherwise\r\n> *\/\r\n> FUNCTION session_enabled_role_varchar(p_role IN VARCHAR2)\r\n> RETURN VARCHAR2;\r\n<\/pre>\n
3400c3400,3401\r\n< IF DVSYS.DBMS_MACUTL.USER_HAS_ROLE_VARCHAR('DV_ACCTMGR', LOGIN_USER) = 'N' THEN\r\n---\r\n> IF DVSYS.DBMS_MACUTL.USER_HAS_ROLE_VARCHAR('DV_ACCTMGR', LOGIN_USER) = 'N' AND\r\n> DVSYS.DBMS_MACUTL.SESSION_ENABLED_ROLE_VARCHAR('DV_ACCTMGR') = 'N' THEN\r\n<\/pre>\n603a604,620\r\n> FUNCTION SESSION_ENABLED_ROLE(P_ROLE IN VARCHAR2)\r\n> RETURN BOOLEAN\r\n> IS EXTERNAL\r\n> LANGUAGE C\r\n> NAME \"kzvIsRoleEnabled\"\r\n> LIBRARY DVSYS.KZV$UTL_LIBT\r\n> WITH CONTEXT\r\n> PARAMETERS\r\n> (CONTEXT,\r\n> P_ROLE STRING,\r\n> P_ROLE INDICATOR SB4,\r\n> P_ROLE LENGTH SB4,\r\n> \r\n> RETURN INDICATOR SB4,\r\n> RETURN SB2\r\n> );\r\n> \r\n776a794,805\r\n> FUNCTION SESSION_ENABLED_ROLE_VARCHAR(P_ROLE IN VARCHAR2)\r\n> RETURN VARCHAR2 IS\r\n> IS_ENABLED BOOLEAN ;\r\n> BEGIN\r\n> IS_ENABLED := DBMS_MACUTL.SESSION_ENABLED_ROLE(P_ROLE);\r\n> \r\n> IF ( IS_ENABLED ) THEN\r\n> RETURN G_YES;\r\n> ELSE\r\n> RETURN G_NO;\r\n> END IF;\r\n> END;\r\n<\/pre>\n
7a8,24\r\n> FUNCTION SESSION_ENABLED_ROLE(P_ROLE IN VARCHAR2)\r\n> RETURN BOOLEAN\r\n> IS EXTERNAL\r\n> LANGUAGE C\r\n> NAME \"kzvIsRoleEnabled\"\r\n> LIBRARY LBACSYS.LBAC$EVENT_LIBT\r\n> WITH CONTEXT\r\n> PARAMETERS\r\n> (CONTEXT,\r\n> P_ROLE STRING,\r\n> P_ROLE INDICATOR SB4,\r\n> P_ROLE LENGTH SB4,\r\n> \r\n> RETURN INDICATOR SB4,\r\n> RETURN SB2\r\n> );\r\n> \r\n14a32,39\r\n> \r\n> \r\n> \r\n> IF (LBACDBA_ROLE_COUNT + DVOWNER_ROLE_COUNT) < 1 THEN\r\n> IF (SESSION_ENABLED_ROLE('DV_OWNER')) THEN\r\n> DVOWNER_ROLE_COUNT := 1;\r\n> END IF;\r\n> END IF;\r\n<\/pre>\n1232c1232,1234\r\n< -- by the find functions.\r\n---\r\n> -- by the find functions. This tag is also used by report\/delete obsolete\r\n> -- functions to restrict what backups to consider and what backups to filter\r\n> -- for backup optimization.\r\n1236c1238\r\n< -- tag of the datafile copies to be translated\r\n---\r\n> -- tag of the datafile copies\/backup sets to be translated\r\n1237a1240,1241\r\n> -- use_like\r\n> -- input tag parameter to be used similar to LIKE semantics in SQL\r\n1239c1243\r\n< PROCEDURE setTag(tag IN varchar2 DEFAULT NULL);\r\n---\r\n> PROCEDURE setTag(tag IN varchar2 DEFAULT NULL, use_like IN number DEFAULT 0);\r\n<\/pre>\n
1224c1224,1226\r\n< -- by the find functions.\r\n---\r\n> -- by the find functions. This tag is also used by report\/delete obsolete\r\n> -- functions to restrict what backups to consider and what backups to filter\r\n> -- for backup optimization.\r\n1228c1230\r\n< -- tag of the datafile copies to be translated\r\n---\r\n> -- tag of the datafile copies\/backup sets to be translated\r\n1229a1232,1233\r\n> -- use_like\r\n> -- input tag parameter to be used similar to LIKE semantics in SQL\r\n1231c1235\r\n< PROCEDURE setTag(tag IN varchar2 DEFAULT NULL);\r\n---\r\n> PROCEDURE setTag(tag IN varchar2 DEFAULT NULL, use_like IN number DEFAULT 0);\r\n<\/pre>\n
39a40,41\r\n> COMP_MIN_SAMPLE_BLOCKS CONSTANT NUMBER := 1000;\r\n> \r\n<\/pre>\n
23a24,28\r\n> V_CODE NUMBER;\r\n> V_ERRM VARCHAR2(128);\r\n> \r\n> \r\n> \r\n105a111,127\r\n> --+\r\n> PROCEDURE LOG_STATUS(MSG VARCHAR2) IS \r\n> BEGIN\r\n> IF DO_DEBUG THEN\r\n> DBMS_OUTPUT.PUT_LINE(MSG);\r\n> END IF;\r\n> \tDBMS_SYSTEM.KSDWRT(1,MSG);\r\n> \t\r\n> END;\r\n> \r\n> --+\r\n> \r\n> \r\n> \r\n> \r\n> \r\n> \r\n304,306d325\r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE ('QPI: GOT lock at :' || SYSTIMESTAMP);\r\n< END IF;\r\n309a329\r\n> LOG_STATUS('QPI: Obtaining lock FAILED, qp_result=' || QP_RESULT || ' at : ' || SYSTIMESTAMP);\r\n310a331,332\r\n> ELSIF QP_RESULT = 0 OR QP_RESULT = 4 THEN\r\n> LOG_STATUS('QPI: Obtaining lock SUCCESSFUL, qp_result=' || QP_RESULT || ' at : ' || SYSTIMESTAMP);\r\n333,334c355,359\r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE ('QPI: Releasing the lock at :' || SYSTIMESTAMP);\r\n---\r\n> \r\n> IF QP_RESULT = 0 THEN\r\n> LOG_STATUS('QPI: Releasing lock SUCCESSFUL, qp_result=' || QP_RESULT || ' at : ' || SYSTIMESTAMP);\r\n> ELSE\r\n> LOG_STATUS('QPI: Releasing lock FAILED, qp_result=' || QP_RESULT || ' at : ' || SYSTIMESTAMP);\r\n431,432c456,457\r\n< V_ERRM := SUBSTR(SQLERRM, 1, 64);\r\n< DBMS_OUTPUT.PUT_LINE('Error code ' || V_CODE || ': ' || V_ERRM);\r\n---\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in config_oinv_jobs, Error code ' || V_CODE || ': ' || V_ERRM);\r\n731a757\r\n> PRAGMA AUTONOMOUS_TRANSACTION;\r\n736,738c762\r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE('QPI: In REFRESH_OPATCH_DATA');\r\n< END IF;\r\n---\r\n> LOG_STATUS('QPI: In REFRESH_OPATCH_DATA');\r\n744,746c768\r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE('QPI: Latest xml inventory is loaded into table');\r\n< END IF;\r\n---\r\n> LOG_STATUS('QPI: Latest xml inventory is loaded into table');\r\n748a771,774\r\n> LOG_STATUS('QPI: Caught error while querying opatch_xml_inv');\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in REFRESH_OPATCH_DATA, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n809a836,842\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_opatch_install_info, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n858a892,898\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_opatch_install_info, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n915a956,962\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in IS_PATCH_INSTALLED, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n974a1022,1028\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_DATA, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1040a1095,1101\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_BUGS, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1061,1063c1122,1126\r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE('QPI: In GET_OPATCH_FILES');\r\n< END IF;\r\n---\r\n> LOG_STATUS('QPI: In GET_OPATCH_FILES');\r\n> \r\n> QP_RESULT := GET_QOPATCH_LOCK();\r\n> \r\n> LOG_STATUS('QPI: Got lock get_opatch_files');\r\n1076a1140,1143\r\n> \r\n> LOG_STATUS('QPI: Release lock get_opatch_files');\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> \r\n1077a1145,1157\r\n> \r\n> EXCEPTION\r\n> WHEN UNABLE_TO_LOCK THEN\r\n> RAISE_APPLICATION_ERROR(-20016, \r\n> 'Unable to get the lock : get_opatch_files : ' || QP_RESULT);\r\n> \r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_FILES, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1127a1208,1214\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_COUNT, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1180a1268,1274\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_PREQS, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1229a1324,1335\r\n> EXCEPTION\r\n> WHEN UNABLE_TO_LOCK THEN\r\n> RAISE_APPLICATION_ERROR(-20016, \r\n> 'Unable to get the lock : get_opatch_install_info : ' || QP_RESULT);\r\n> \r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in GET_OPATCH_OLAYS, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1284a1391,1397\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in PATCH_CONFLICT_DETECTION, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n1564,1565c1677,1678\r\n< V_ERRM := SUBSTR(SQLERRM, 1, 64);\r\n< DBMS_OUTPUT.PUT_LINE('Error code ' || V_CODE || ': ' || V_ERRM);\r\n---\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in add_oinv_job, Error code ' || V_CODE || ': ' || V_ERRM);\r\n1926a2040,2043\r\n> WHEN UNABLE_TO_LOCK THEN\r\n> RAISE_APPLICATION_ERROR(-20016, \r\n> 'Unable to get the lock : get_pending_activity : ' || QP_RESULT);\r\n> \r\n1932,1933c2049,2052\r\n< \r\n< WHEN UNABLE_TO_LOCK THEN\r\n---\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_pending_activity, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n1935,1937c2054\r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE('QPI: org_node and inst resore 2:' || ORG_NODE || ':' || ORG_INST);\r\n< END IF; \r\n---\r\n> LOG_STATUS('QPI: org_node and inst resore 2:' || ORG_NODE || ':' || ORG_INST);\r\n1939,1945d2055\r\n< \r\n< IF DO_DEBUG THEN\r\n< DBMS_OUTPUT.PUT_LINE('QPI: Unable to get the lock : get_pending_activity');\r\n< END IF;\r\n< RAISE_APPLICATION_ERROR(-20016, 'Unable to get the lock : get_pending_activity :' || QP_RESULT );\r\n< \r\n< WHEN OTHERS THEN\r\n1949c2059\r\n< \r\n---\r\n> \r\n2016a2127,2133\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_opatch_lsinventory, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n2359,2365c2476,2485\r\n< WHEN NO_DATA_FOUND THEN\r\n< RAISE_APPLICATION_ERROR(-20005, 'Job ' || JOBNAME || ' cleanup failed');\r\n< WHEN UNABLE_TO_LOCK THEN\r\n< RAISE_APPLICATION_ERROR(-20016, \r\n< 'Unable to get the lock : clean_metadata : ' || QP_RESULT);\r\n< WHEN OTHERS THEN\r\n< RAISE;\r\n---\r\n> WHEN UNABLE_TO_LOCK THEN\r\n> RAISE_APPLICATION_ERROR(-20016, \r\n> 'Unable to get the lock : clean_metadata : ' || QP_RESULT);\r\n> WHEN OTHERS THEN\r\n> V_CODE := SQLCODE;\r\n> V_ERRM := SUBSTR(SQLERRM, 1, 128);\r\n> LOG_STATUS('QPI: in get_opatch_lsinventory, ERROR code ' || V_CODE || ' : ' || V_ERRM);\r\n> QP_RESULT:= RELEASE_QOPATCH_LOCK();\r\n> RAISE;\r\n> \r\n<\/pre>\n