Package Differences between Oracle 11.2.0.4 and 12.1.0.2?

The question sounds pretty trivial:

Which packages did exist in Oracle 11.2.0.4 but don’t exist in Oracle 12.1.0.2 anymore?

And going a bit deeper into the topic,

Which procedures and functions calls of SYS packages have been changed since then?

A colleague of mine (thanks to Thomas Kempkens from ACS Support for writing up a fancy procedure – all credits go to him) had to dig this out for a customer,

See the result.
These packages don’t exist in Oracle 12.1.0.2 anymore but did exist in Oracle 11.2.0.4 (without PSUs):

CWM2_OLAP_INSTALLER
DBMS_AMD
DBMS_APPCTX
DBMS_DBLINK
DBMS_DM_IMP_INTERNAL
DBMS_DM_UTIL_INTERNAL
DBMS_DUMA_INTERNAL
DBMS_JDM_INTERNAL
DBMS_RULE_COMPATIBLE_90
DBMS_SQL2
DBMS_XDSUTL
DBMS_XS_SECCLASS_INT
DBMS_XS_SECCLASS_INT_FFI
EXF$DBMS_EXPFIL_SYSPACK
HTMLDB_SYSTEM
ODM_ABN_MODEL
SQLJUTL2

17 packages don’t exist anymore.

And this is the list of
Procedures and Functions Calls inside of Oracle SYS packages which have changed in Oracle 12.1.0.2:

PACKAGE_NAME               SUBTYPE    SUBTYPE_NAME
-------------------------- ---------- ------------------------------------------------
CWM2_OLAP_INSTALLER        PROCEDURE  VALIDATE_CWM2_INSTALL
DBMS_AMD                   PROCEDURE  MOVE_OLAP_CATALOG
DBMS_APPCTX                PROCEDURE  CLEAR_CONTEXT
DBMS_APPCTX                PROCEDURE  SET_CONTEXT
DBMS_AQADM_SYS             PROCEDURE  GET_CORR_MSG
DBMS_AQADM_SYS             PROCEDURE  RESET_CORR_MSG
DBMS_AQADM_SYSCALLS        PROCEDURE  KWQA_3GL_UPDPERSTATS
DBMS_DATA_MINING           FUNCTION   GET_MODEL_DETAILS_ABN RETURNS DM_ABN_DETAILS
DBMS_DATA_MINING_INTERNAL  PROCEDURE  CREATE_TEMP_META_TABLE
DBMS_DBLINK                PROCEDURE  UPGRADE
DBMS_DDL_INTERNAL          FUNCTION   GEN_NEW_OBJECT_ID RETURNS BINARY_INTEGER
DBMS_DM_EXP_INTERNAL       FUNCTION   GET_TRACE RETURNS BOOLEAN
DBMS_DM_EXP_INTERNAL       PROCEDURE  DELETE_FROM_TEMP
DBMS_DM_EXP_INTERNAL       PROCEDURE  DO_TEMP_TABLE
DBMS_DM_EXP_INTERNAL       PROCEDURE  DUMP_STATUS
DBMS_DM_EXP_INTERNAL       PROCEDURE  GET_LIST_MODELS
DBMS_DM_EXP_INTERNAL       PROCEDURE  INSERT_LIST_MODELS
DBMS_DM_EXP_INTERNAL       PROCEDURE  SET_TRACE
DBMS_DM_IMP_INTERNAL       PROCEDURE  REGISTER_TEMP_TABLE
DBMS_DM_IMP_INTERNAL       PROCEDURE  UNREGIST_TEMP_TABLE
DBMS_DM_MODEL_EXP          FUNCTION   INSTANCE_INFO_EXP RETURNS VARCHAR2
DBMS_DM_MODEL_EXP          FUNCTION   SCHEMA_INFO_EXP RETURNS VARCHAR2
DBMS_DM_MODEL_EXP          PROCEDURE  SCHEMA_CALLOUT
DBMS_DM_UTIL               PROCEDURE  DISPLAY_MSG
DBMS_DM_UTIL               PROCEDURE  DUMP_MSG
DBMS_DM_UTIL_INTERNAL      PROCEDURE  DUMP_DM_TRACE
DBMS_DUMA_INTERNAL         FUNCTION   GET_PROPERTY RETURNS NUMBER
DBMS_DUMA_INTERNAL         FUNCTION   READ_LONG_TO_BLOB RETURNS BLOB
DBMS_DUMA_INTERNAL         PROCEDURE  CONVERT_LONG
DBMS_DUMA_INTERNAL         PROCEDURE  SCAN_TABLE
DBMS_DUMA_INTERNAL         PROCEDURE  WRITE_BLOB_TO_LONG
DBMS_INTERNAL_LOGSTDBY     PROCEDURE  EDS_EVOLVE_TABLE_1_FINISH
DBMS_INTERNAL_LOGSTDBY     PROCEDURE  END_INSTANTIATION
DBMS_INTERNAL_LOGSTDBY     PROCEDURE  INSTANTIATE_FEATURE
DBMS_INTERNAL_LOGSTDBY     PROCEDURE  LOCK_TABLES
DBMS_INTERNAL_LOGSTDBY     PROCEDURE  PREPARE_INSTANTIATION
DBMS_INTERNAL_LOGSTDBY     PROCEDURE  REGISTER_SCHEMA
DBMS_INTERNAL_LOGSTDBY     PROCEDURE  UNSUPPORTED_DML
DBMS_JAVA                  FUNCTION   DEPLOY_INVOKE RETURNS VARCHAR2
DBMS_JAVA                  FUNCTION   DROP_JAR RETURNS NUMBER
DBMS_JAVA                  FUNCTION   FINISH_LOADING_JAR RETURNS NUMBER
DBMS_JAVA                  FUNCTION   GETSOURCECHUNK RETURNS VARCHAR2
DBMS_JAVA                  FUNCTION   HANDLEMD5 RETURNS RAW
DBMS_JAVA                  FUNCTION   INITGETSOURCECHUNKS RETURNS NUMBER
DBMS_JAVA                  FUNCTION   JAR_STATUS RETURNS NUMBER
DBMS_JAVA                  FUNCTION   RJBC_INIT RETURNS VARCHAR2
DBMS_JAVA                  FUNCTION   RJBC_NORMALIZE RETURNS NUMBER
DBMS_JAVA                  FUNCTION   RJBC_REQUEST RETURNS NUMBER
DBMS_JAVA                  FUNCTION   RJBC_RESPOND RETURNS NUMBER
DBMS_JAVA                  FUNCTION   START_LOADING_JAR RETURNS NUMBER
DBMS_JAVA                  PROCEDURE  DEPLOY_COPY
DBMS_JAVA                  PROCEDURE  DEPLOY_OPEN
DBMS_JAVA                  PROCEDURE  RJBC_DONE
DBMS_JAVA                  PROCEDURE  RJBC_OUTPUT
DBMS_JDM_INTERNAL          FUNCTION   GET_JDM_ATTR_NAMES RETURNS JDM_ATTR_NAMES
DBMS_JDM_INTERNAL          FUNCTION   GET_JDM_NUM_VALS RETURNS JDM_NUM_VALS
DBMS_JDM_INTERNAL          FUNCTION   GET_JDM_STR_VALS RETURNS JDM_STR_VALS
DBMS_JDM_INTERNAL          FUNCTION   TO_CHAR_VARRAY RETURNS VARCHAR2
DBMS_JDM_INTERNAL          FUNCTION   UNIQUE_OBJECT_NAME RETURNS VARCHAR2
DBMS_JDM_INTERNAL          PROCEDURE  APPLY_TASK
DBMS_JDM_INTERNAL          PROCEDURE  BUILD_TASK
DBMS_JDM_INTERNAL          PROCEDURE  EXPLAIN_TASK
DBMS_JDM_INTERNAL          PROCEDURE  EXPORT_TASK
DBMS_JDM_INTERNAL          PROCEDURE  IMPORT_TASK
DBMS_JDM_INTERNAL          PROCEDURE  PREDICT_TASK
DBMS_JDM_INTERNAL          PROCEDURE  PROFILE_TASK
DBMS_JDM_INTERNAL          PROCEDURE  SQL_APPLY_TASK
DBMS_JDM_INTERNAL          PROCEDURE  TEST_TASK
DBMS_JDM_INTERNAL          PROCEDURE  XFORM_SEQ_TASK
DBMS_JDM_INTERNAL          PROCEDURE  XFORM_TASK
DBMS_LOGMNR_INTERNAL       PROCEDURE  ADDXTENDEDPKLOGGROUP
DBMS_LOGMNR_INTERNAL       PROCEDURE  DROPXTENDEDPKLOGGROUP
DBMS_LOGMNR_INTERNAL       PROCEDURE  KRVGDRM2
DBMS_LOGMNR_INTERNAL       PROCEDURE  LOGMNR_KRVILD
DBMS_LOGMNR_INTERNAL       PROCEDURE  LOGMNR_KRVIULD
DBMS_LOGMNR_INTERNAL       PROCEDURE  SET_PARAMETER
DBMS_LOGMNR_INTERNAL       PROCEDURE  UNSET_PARAMETER
DBMS_LOGSTDBY              FUNCTION   VALIDATE_AUTH RETURNS BOOLEAN
DBMS_LOGSTDBY              PROCEDURE  EDS_EVOLVE_TABLE
DBMS_METADATA_INT          PROCEDURE  CLEAR_CACHE
DBMS_METADATA_INT          PROCEDURE  CLEAR_XSL_CACHE
DBMS_OBJECTS_UTILS         FUNCTION   SPLIT_SOURCE RETURNS NUMBER
DBMS_OBJECTS_UTILS         PROCEDURE  RECOMPILE_TYPES
DBMS_OBJECTS_UTILS         PROCEDURE  UPDATE_TYPES
DBMS_REPORT                FUNCTION   STORE_FILE RETURNS NUMBER
DBMS_REPORT                PROCEDURE  CREATE_SHARED_DIRECTORY
DBMS_REPORT                PROCEDURE  DROP_SHARED_DIRECTORY
DBMS_RMIN                  PROCEDURE  INSTALL
DBMS_RMIN                  PROCEDURE  RM$_CALIBRATE_IO
DBMS_RMIN                  PROCEDURE  RM$_CLRPAREA
DBMS_RMIN                  PROCEDURE  RM$_CONSUMER_GROUP_MAPPING_PRI
DBMS_RMIN                  PROCEDURE  RM$_CRTPAREA
DBMS_RMIN                  PROCEDURE  RM$_CUP_CATEGORY
DBMS_RMIN                  PROCEDURE  RM$_CUP_GROUP
DBMS_RMIN                  PROCEDURE  RM$_CUP_PLAN
DBMS_RMIN                  PROCEDURE  RM$_CUP_PLAN_DIRECTIVE
DBMS_RMIN                  PROCEDURE  RM$_CUP_STORAGE_POOL_MAPPING
DBMS_RMIN                  PROCEDURE  RM$_DRP_CATEGORY
DBMS_RMIN                  PROCEDURE  RM$_DRP_GROUP
DBMS_RMIN                  PROCEDURE  RM$_DRP_PLAN
DBMS_RMIN                  PROCEDURE  RM$_DRP_PLAN_CSD
DBMS_RMIN                  PROCEDURE  RM$_DRP_PLAN_DIRECTIVE
DBMS_RMIN                  PROCEDURE  RM$_SET_CAPABILITY
DBMS_RMIN                  PROCEDURE  RM$_SET_CONSUMER_GROUP_MAPPING
DBMS_RMIN                  PROCEDURE  RM$_SET_INSTANCE_CAPABILITY
DBMS_RMIN                  PROCEDURE  RM$_SUBPAREA
DBMS_RMIN                  PROCEDURE  RM$_SWTCH_SESSION_GROUP
DBMS_RMIN                  PROCEDURE  RM$_SWTCH_USR_GROUP
DBMS_RMIN                  PROCEDURE  RM$_VLDPAREA
DBMS_RMIN                  PROCEDURE  UNINSTALL
DBMS_RULE_COMPATIBLE_90    FUNCTION   INCOMPATIBLE_RULES_ENGINE_OBJ RETURNS NUMBER
DBMS_RULE_COMPATIBLE_90    PROCEDURE  DOWNGRADE_RULE_OBJECTS
DBMS_RULE_COMPATIBLE_90    PROCEDURE  INCOMPATIBLE_EVCTXS
DBMS_RULE_COMPATIBLE_90    PROCEDURE  INCOMPATIBLE_RULES
DBMS_RULE_COMPATIBLE_90    PROCEDURE  INCOMPATIBLE_RULESETS
DBMS_RULE_COMPATIBLE_90    PROCEDURE  UPGRADE_RULE_OBJECTS
DBMS_SPM_INTERNAL          FUNCTION   FETCH_PLAN_INFO RETURNS REF CURSOR
DBMS_SPM_INTERNAL          PROCEDURE  GET_SPM_HINTSET
DBMS_SQL2                  PROCEDURE  EXPAND_SQL_TEXT
DBMS_SQL2                  PROCEDURE  PARSE
DBMS_STATS                 FUNCTION   TO_CASCADE_TYPE RETURNS BOOLEAN
DBMS_STATS                 FUNCTION   TO_DEGREE_TYPE RETURNS NUMBER
DBMS_STATS                 FUNCTION   TO_ESTIMATE_PERCENT_TYPE RETURNS NUMBER
DBMS_STATS                 FUNCTION   TO_PUBLISH_TYPE RETURNS BOOLEAN
DBMS_STATS_INTERNAL        FUNCTION   COMPOSE_HASHVAL_CLOB RETURNS CLOBTAB
DBMS_STATS_INTERNAL        FUNCTION   GET_CHTAB RETURNS CHTAB
DBMS_STATS_INTERNAL        FUNCTION   GET_SYNOPSIS_BLKCNT RETURNS NUMBER(38)
DBMS_STATS_INTERNAL        PROCEDURE  DELETE_TABLE_SYNOPSIS
DBMS_STATS_INTERNAL        PROCEDURE  EXPORT_SYNOPSIS_HEAD
DBMS_SWRF_REPORT_INTERNAL  FUNCTION   TO_1000S RETURNS VARCHAR2
DBMS_SWRF_REPORT_INTERNAL  FUNCTION   TO_1024S RETURNS VARCHAR2
DBMS_WORKLOAD_REPLAY       FUNCTION   SYNCPOINT_WAIT_TO_POST RETURNS NUMBER
DBMS_WRR_INTERNAL          FUNCTION   DATE_TO_EPOCH_SECS RETURNS BINARY_INTEGER
DBMS_WRR_INTERNAL          FUNCTION   IS_CONSOLIDATED_DIR RETURNS BOOLEAN
DBMS_XDS                   PROCEDURE  REFRESH_DSD
DBMS_XDSUTL                PROCEDURE  INVALIDATE_DSD_CACHE
DBMS_XDSUTL                PROCEDURE  INVALIDATE_DSD_CACHE_BY_ACLID
DBMS_XS_SECCLASS_INT       PROCEDURE  DELETE_SEC_CLASS
DBMS_XS_SECCLASS_INT       PROCEDURE  GET_LEAF_PRIVILEGES
DBMS_XS_SECCLASS_INT_FFI   PROCEDURE  DELETE_SEC_CLASS
DBMS_XS_SECCLASS_INT_FFI   PROCEDURE  GET_LEAF_PRIVILEGES
DBMS_XS_SESSIONS           FUNCTION   CHECK_ROLE RETURNS BOOLEAN
DBMS_XS_SESSIONS           FUNCTION   CHECK_SESSION RETURNS BOOLEAN
DBMS_XS_SESSIONS           FUNCTION   GET_SESSIONID_FROM_COOKIE RETURNS RAW
DBMS_XS_SESSIONS           PROCEDURE  ABORTATTACH_SESSION
DBMS_XS_SESSIONS           PROCEDURE  GET_SESSION_COOKIE
DBMS_XS_SESSIONS           PROCEDURE  SET_NAMESPACE_ACL
DBMS_XS_SESSIONS           PROCEDURE  SET_NAMESPACE_HANDLER
DBMS_XS_SESSIONS_FFI       PROCEDURE  ABORTATTACH_SESSION
DBMS_XS_SESSIONS_FFI       PROCEDURE  CHECK_ROLE
DBMS_XS_SESSIONS_FFI       PROCEDURE  CHECK_SESSION
DBMS_XS_SESSIONS_FFI       PROCEDURE  GET_SESSION_COOKIE
DBMS_XS_SESSIONS_FFI       PROCEDURE  SET_NAMESPACE_ACL
DBMS_XS_SESSIONS_FFI       PROCEDURE  SET_NAMESPACE_HANDLER
DMP_SEC                    FUNCTION   GET_MODEL_DETAILS_ABN RETURNS VARCHAR2(32767)
DMP_SYS                    PROCEDURE  DUMP_MODEL_REC
DMP_SYS                    PROCEDURE  DUMP_TRACE
DMP_SYS                    PROCEDURE  DUMP_VARCHAR2A
DMP_SYS                    PROCEDURE  DUMP_VARCHAR2S
DM_QGEN                    PROCEDURE  LS_DUMP
EXF$DBMS_EXPFIL_SYSPACK    FUNCTION   GET_CMTSCN_FOR_XID RETURNS NUMBER
EXF$DBMS_EXPFIL_SYSPACK    FUNCTION   GET_EXPRID_4M_TEXTID RETURNS VARCHAR2
EXF$DBMS_EXPFIL_SYSPACK    FUNCTION   GET_SPATIAL_MDATAREP RETURNS VARCHAR2
EXF$DBMS_EXPFIL_SYSPACK    FUNCTION   GET_TAB_NAME RETURNS VARCHAR2
EXF$DBMS_EXPFIL_SYSPACK    FUNCTION   GET_TAB_OWNER RETURNS VARCHAR2
EXF$DBMS_EXPFIL_SYSPACK    FUNCTION   GET_TYPELV_STATUS RETURNS VARCHAR2
EXF$DBMS_EXPFIL_SYSPACK    FUNCTION   GET_TYPE_OID RETURNS RAW
EXF$DBMS_EXPFIL_SYSPACK    FUNCTION   PROC_IS_DEFINERS RETURNS NUMBER
EXF$DBMS_EXPFIL_SYSPACK    FUNCTION   TAB_COLUMN_EXISTS RETURNS NUMBER
EXF$DBMS_EXPFIL_SYSPACK    PROCEDURE  CLR_EXP_DEPACTION
EXF$DBMS_EXPFIL_SYSPACK    PROCEDURE  CLR_OBJECT_NOEXP
EXF$DBMS_EXPFIL_SYSPACK    PROCEDURE  CLR_USER_NOEXP
EXF$DBMS_EXPFIL_SYSPACK    PROCEDURE  DOWNGRADE_COMPILED_SPARSE
EXF$DBMS_EXPFIL_SYSPACK    PROCEDURE  PARSE_PROC_AS_OWNER
EXF$DBMS_EXPFIL_SYSPACK    PROCEDURE  PARSE_PROC_AS_OWNER2
EXF$DBMS_EXPFIL_SYSPACK    PROCEDURE  SET_EXP_DEPACTION
EXF$DBMS_EXPFIL_SYSPACK    PROCEDURE  SET_OBJECT_NOEXP
HTMLDB_SYSTEM              FUNCTION   VERIFY_USER RETURNS BINARY_INTEGER
INITJVMAUX                 FUNCTION   DO_JIS_DROP RETURNS BOOLEAN
KUPD$DATA                  FUNCTION   CONVENTIONAL_LOAD_CALLOUT RETURNS BINARY_INTEGER
KUPF$FILE_INT              FUNCTION   GET_ENCPWD RETURNS RAW
KUPF$FILE_INT              FUNCTION   GET_OBFPWD RETURNS RAW
KUPF$FILE_INT              PROCEDURE  ENCRYPT_PWD
KUPP$PROC                  PROCEDURE  INTALGCONV
LOGMNR_DICT_CACHE          PROCEDURE  PURGE_SCN
LOGSTDBY_INTERNAL          PROCEDURE  EDS_EVOLVE_TABLE_1_I
ODM_ABN_MODEL              PROCEDURE  BUILD
ODM_ABN_MODEL              PROCEDURE  ESTIMATE_FEATUREBLD_TIME
ODM_ABN_MODEL              PROCEDURE  GET_MODEL_STATE
ODM_CLUSTERING_UTIL        FUNCTION   IS_DEBUG_ENABLED RETURNS BOOLEAN
ODM_MODEL_UTIL             FUNCTION   UNIQUE_SEQUENCE_NAME RETURNS VARCHAR2(30)
ODM_MODEL_UTIL             PROCEDURE  CREATE_SEQUENCE
ODM_MODEL_UTIL             PROCEDURE  DEBUG_DUMP
ODM_MODEL_UTIL             PROCEDURE  DROP_SEQUENCE
ODM_MODEL_UTIL             PROCEDURE  GET_TIME_MILLISECONDS
ODM_UTIL                   FUNCTION   COMPUTE_LOG_COMBINATIONS RETURNS NUMBER
PRVT_RTADDM                FUNCTION   EXTRACTOSSTAT RETURNS NUMBER
PRVT_RTADDM                FUNCTION   GETDATA RETURNS CLOB_T
PRVT_RTADDM                FUNCTION   GETVERSION RETURNS VARCHAR2
SQLJUTL2                   FUNCTION   EVALUATE RETURNS LONG RAW
SQLJUTL2                   FUNCTION   INVOKE RETURNS LONG RAW
SQLJUTL2                   FUNCTION   REFLECT RETURNS LONG
SQLJUTL2                   FUNCTION   REFLECT2 RETURNS CLOB
STANDARD                   FUNCTION   ASCII RETURNS BINARY_INTEGER

204 procedure and function calls have been changed.

— Mike

PS: The above listening is without PSUs applied – I learned that the list my vary slightly based on the PSUs or BPs you have applied. Credits to my colleague Katsumi-san, who pointed my to the DBMS_OPTIM_BUNDLE package which seems to be introduced with the October 2014 PSU. Philippe Fierens has blogged about the package: http://pfierens.blogspot.co.uk/2014_10_01_archive.html

2 thoughts on “Package Differences between Oracle 11.2.0.4 and 12.1.0.2?

Leave a Reply

Your email address will not be published. Required fields are marked *