White Listed PL/SQL Programs in Oracle Database 18c

I’ve recently installed plscope-utils in an Oracle Database 18c instance. A package body using the SYS.UTL_XML.ParseQuery function failed to compile. The error message was: PLS-00306: wrong number or types of arguments in call to ‘PARSEQUERY’. Fixing that was easy. I just had to pass the new mandatory currUid parameter. But then I’ve got the next error message.

PLS-00904: insufficient privilege to access object PARSEQUERY.

The excerpt of the SYS.UTL_XML package specification reveals the cause for this error.

The accessible_by_clause on line 13 restricts the access of the procedure parseQuery to the package SYS.DBMS_METADATA. It looks like Oracle started to use this 12.1 feature in 12.2 and is tightening its APIs with new releases.

Actually, that’s good. For me, an accessor is comparable to a constraint in a data model. A constraint describes a part of a model in a machine-readable way, so that it can be enforced and visualized efficiently. An accessor is just a constraint for a named PL/SQL unit. The accessible-by-lists (aka white lists) are helpful to plan upgrade projects, to validate role concepts/implementations or to support development tasks such as generating utPLSQL unit test stubs for a PL/SQL package (ignoring inaccessible subprograms).

However, currently it is not that easy to get the information about PL/SQL units and subprograms which are restricted by an accessible_by_clause.  There is no Oracle data dictionary view or API exposing this data. The Oracle enhancement request 27871459 addresses this issue. If you have an Oracle support account, please open an SR and add your CSI to this enhancement requests. This should be a well-known task for an Oracle support engineer.

I’ve created a script named procedure_accessors.sql to query accessors for all PL/SQL units and its subprograms in Oracle maintained schemas of an Oracle Database instance. The result has the granularity of the Oracle data dictionary view dba_procedures. Usually I would use the result of the named query procedure_accessors directly, but for this blog post I’ve done some aggregation and introduced the column accessor_list containing a comma separated list of all accessors of a procedure.

Please note, that this query requires an Oracle Database 12c Release 2 (12.2) instance or newer.

The following result is based on an Oracle Database 18c installation. Use the search box to filter the result table, e.g. for UTL_XML only 3 result rows are shown. I hope it’s helpful.

OwnerObject TypeObject NameProcedure NameAccessor List
APEX_050100PACKAGEWWV_FLOW_ADVISOR_CHECKS_INTWWV_FLOW_ADVISOR_CHECKS_API
APEX_050100PACKAGEWWV_FLOW_APP_INSTALL_INTWWV_FLOW_IMP_PARSER, WWV_FLOW_PKG_APP_PARSER
APEX_050100PACKAGEWWV_FLOW_REGION_LISTWWV_FLOW_REGION_NATIVE
APEX_050100PACKAGEWWV_FLOW_SPATIAL_INTWWV_FLOW_SPATIAL_API
CTXSYSPACKAGEDRIACCHELPPACKAGE DRIACC
CTXSYSPACKAGEDRIUTLPARSE_OBJECT_NAMEPACKAGE DRVUTL, PROCEDURE PARSE_OBJECT_NAME
CTXSYSPACKAGEDRVODMSVM_TRAINCTXSYS.CTX_CLS
DVSYSPACKAGECONFIGURE_DV_INTERNALPROCEDURE SYS.CONFIGURE_DV
GSMADMIN_INTERNALPACKAGEDBMS_GSM_COMMONGETDBPARAMETERNUMPACKAGE DBMS_GSM_CLOUDADMIN, PACKAGE DBMS_GSM_COMMON, PACKAGE DBMS_GSM_DBADMIN, PACKAGE DBMS_GSM_POOLADMIN, PACKAGE DBMS_GSM_UTILITY, PACKAGE GGSYS.GGSHARDING, PROCEDURE EXECUTEDDL
GSMADMIN_INTERNALPACKAGEDBMS_GSM_COMMONGETDBPARAMETERSTRPACKAGE DBMS_GSM_CLOUDADMIN, PACKAGE DBMS_GSM_COMMON, PACKAGE DBMS_GSM_DBADMIN, PACKAGE DBMS_GSM_POOLADMIN, PACKAGE GGSYS.GGSHARDING
GSMADMIN_INTERNALPACKAGEDBMS_GSM_COMMONRESETDBPARAMETERPACKAGE DBMS_GSM_CLOUDADMIN, PACKAGE DBMS_GSM_COMMON, PACKAGE DBMS_GSM_DBADMIN, PACKAGE DBMS_GSM_POOLADMIN, PACKAGE GGSYS.GGSHARDING
GSMADMIN_INTERNALPACKAGEDBMS_GSM_COMMONSETDBPARAMETERPACKAGE DBMS_GSM_CLOUDADMIN, PACKAGE DBMS_GSM_COMMON, PACKAGE DBMS_GSM_DBADMIN, PACKAGE DBMS_GSM_POOLADMIN, PACKAGE GGSYS.GGSHARDING
GSMADMIN_INTERNALPACKAGEDBMS_GSM_UTILITYGENERATECHANGELOGENTRYPACKAGE DBMS_GSM_CLOUDADMIN, PACKAGE DBMS_GSM_COMMON, PACKAGE DBMS_GSM_DBADMIN, PACKAGE DBMS_GSM_POOLADMIN, PACKAGE GGSYS.GGSHARDING
GSMADMIN_INTERNALPACKAGEEXCHANGEPACKAGE GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN, PACKAGE SYS.EXCH_TEST
SYSFUNCTIONISXMLTYPETABLE_INTERNALISXMLTYPETABLE
SYSPACKAGECDBVIEW_INTERNALPACKAGE SYS.CDBVIEW
SYSPACKAGEDBMS_AQADM_INVPACKAGE SYS.DBMS_AQADM, SYS.DBMS_AQADM_SYS, SYS.DBMS_AQJMS, SYS.DBMS_AQ_SYS_IMP_INTERNAL, SYS.DBMS_PRVTAQIM, SYS.DBMS_PRVTAQIS, SYS.DBMS_PRVTSQDS, SYS.DBMS_PRVTSQIS
SYSPACKAGEDBMS_AQADM_SYSCALLSPACKAGE SYS.DBMS_AQADM, SYS.DBMS_AQ, SYS.DBMS_AQADM_INV, SYS.DBMS_AQADM_SYS, SYS.DBMS_AQJMS, SYS.DBMS_AQJMS_INTERNAL, SYS.DBMS_AQ_IMPORT_INTERNAL, SYS.DBMS_AQ_IMP_ZECURITY, SYS.DBMS_AQ_SYS_EXP_INTERNAL, SYS.DBMS_AQ_SYS_IMP_INTERNAL, SYS.DBMS_PRVTAQIM, SYS.DBMS_PRVTAQIP, SYS.DBMS_PRVTAQIS, SYS.DBMS_PRVTSQDS, SYS.DBMS_PRVTSQIS, SYS.DBMS_RULEADM_INTERNAL, SYS.DBMS_RULE_ADM, SYS.DBMS_STREAMS_CONTROL_ADM
SYSPACKAGEDBMS_AWR_PROTECTEDDBMS_AWR_REPORT_LAYOUT, DBMS_SWRF_REPORT_INTERNAL
SYSPACKAGEDBMS_EXPORT_EXTENSION_IPACKAGE SYS.DBMS_EXPORT_EXTENSION
SYSPACKAGEDBMS_ISCHED_CHAIN_CONDITIONDELETE_STEP_NAME_TABLEPACKAGE DBMS_ISCHED
SYSPACKAGEDBMS_JSON0PACKAGE XDB.DBMS_JSON
SYSPACKAGEDBMS_METADATA_UTILSET_MARKERPACKAGE SYS.DBMS_METADATA_INT
SYSPACKAGEDBMS_MVIEW_STATS_INTERNALDBMS_MVIEW_STATS
SYSPACKAGEDBMS_PCLXUTIL_INTERNALPACKAGE SYS.DBMS_PCLXUTIL
SYSPACKAGEDBMS_PLUGTSPLTS_NEWDATAFILEPACKAGE SYS.KUPW$WORKER
SYSPACKAGEDBMS_RAT_MASK_INTERNALSYS.DBMS_RAT_MASK
SYSPACKAGEDBMS_RECO_SCRIPT_INTEXTENDED_DATATYPE_SUPPORT, SYS.DBMS_RECOVERABLE_SCRIPT, SYS.DBMS_RECO_SCRIPT_INVOK, SYS.DBMS_STREAMS, SYS.DBMS_STREAMS_ADM, SYS.DBMS_STREAMS_ADM_IVK, SYS.DBMS_STREAMS_ADM_UTL, SYS.DBMS_STREAMS_ADM_UTL_INVOK, SYS.DBMS_STREAMS_MC, SYS.DBMS_STREAMS_MT, SYS.DBMS_STREAMS_RPC
SYSPACKAGEDBMS_RESULT_CACHE_INTERNALDBMS_NETWORK_ACL_ADMIN, RC_INTERNAL_TEST
SYSPACKAGEDBMS_SNAPSHOT_KKXRCAPACKAGE DBMS_SNAPSHOT
SYSPACKAGEDBMS_SODA_UTILPACKAGE SYS.DBMS_SODA, PACKAGE XDB.DBMS_SODA_ADMIN, PACKAGE XDB.DBMS_SODA_DML, PACKAGE XDB.DBMS_SODA_DOM
SYSPACKAGEDBMS_SQLTUNE_INTERNALEXEC_EMX_TUNING_TASK_CALLOUTTYPE SYS.WRI$_REPT_SQLT
SYSPACKAGEDBMS_SQLTUNE_INTERNALI_PROCESS_SQLPACKAGE SYS.DBMS_SQLDIAG, PACKAGE SYS.DBMS_SQLTCB_INTERNAL, PACKAGE SYS.DBMS_STATS_INTERNAL, PACKAGE SYS.DBMS_WORKLOAD_REPLAY_I, PACKAGE SYS.DBMS_XPLAN
SYSPACKAGEDBMS_SQLTUNE_INTERNALTEST_PROCESS_SQLSETPACKAGE SYS.DBMS_STATS
SYSPACKAGEDBMS_SQLTUNE_UTIL0CHECK_DV_ACCESSPACKAGE SYS.DBMS_SQLTUNE
SYSPACKAGEDBMS_SQLTUNE_UTIL1GET_SEQ_REMOTEPACKAGE SYS.DBMS_SQLTUNE_INTERNAL
SYSPACKAGEDBMS_STATS_INTERNALCREATE_TEMPPACKAGE DBMS_STATS
SYSPACKAGEDBMS_STATS_INTERNALPOPULATE_TEMP_INSERTPACKAGE DBMS_STATS
SYSPACKAGEDBMS_STATS_INTERNAL_AGGPACKAGE DBMS_STATS, PACKAGE DBMS_STATS_INTERNAL
SYSPACKAGEDBMS_STREAMS_ADM_UTL_INTSYS.DBMS_STREAMS_ADM_UTL, SYS.DBMS_STREAMS_MT
SYSPACKAGEDBMS_STREAMS_RPCREMOVE_FILE_RCREMOVE_FILE
SYSPACKAGEDBMS_STREAMS_TBS_INTDBMS_FILE_GROUP_UTL_INVOK, DBMS_STREAMS_ADM_UTL, DBMS_STREAMS_MT, DBMS_STREAMS_RPC, DBMS_STREAMS_TABLESPACE_ADM, DBMS_STREAMS_TBS_INT_INVOK
SYSPACKAGEDBMS_SUMVDMDBMS_DIMENSION, DBMS_SUMMARY
SYSPACKAGEDBMS_SYNC_REFRESH_INTERNALDBMS_SYNC_REFRESH
SYSPACKAGEDBMS_TRANSFORM_INTERNALPACKAGE SYS.DBMS_TRANSFORM, SYS.DBMS_AQADM, SYS.DBMS_TRANSFORM_EXIMP, SYS.DBMS_TRANSFORM_EXIMP_INTERNAL
SYSPACKAGEDBMS_TTSCONVERTENCRYPTEDDATAFILECOPYPACKAGE SYS.KUPW$WORKER
SYSPACKAGEDBMS_TTSGET_AFN_DBIDPACKAGE SYS.KUPW$WORKER
SYSPACKAGEDBMS_TTSGET_AFN_DBIDXENDIANPACKAGE SYS.KUPW$WORKER
SYSPACKAGEDBMS_TTSPUT_PROTECTED_TSE_KEYPACKAGE SYS.KUPW$WORKER
SYSPACKAGEDBMS_UMF_PROTECTEDDBMS_ASH_INTERNAL, DBMS_AWR_REPORT_LAYOUT, DBMS_SWRF_REPORT_INTERNAL, DBMS_WORKLOAD_REPOSITORY
SYSPACKAGEDBMS_WRR_PROTECTEDDBMS_RAT_MASK_INTERNAL, DBMS_WORKLOAD_CAPTURE, DBMS_WORKLOAD_REPLAY, DBMS_WORKLOAD_REPLAY_I
SYSPACKAGEDBMS_XDB_UTILPACKAGE SYS.XDB_MIGRATESCHEMA, PACKAGE XDB.DBMS_CLOBUTIL, PACKAGE XDB.DBMS_RESCONFIG, PACKAGE XDB.DBMS_XDBZ, PACKAGE XDB.DBMS_XDBZ0, PACKAGE XDB.DBMS_XDB_ADMIN, PACKAGE XDB.DBMS_XEVENT, PACKAGE XDB.DBMS_XMLDOM
SYSPACKAGEDBMS_XDS_INTPACKAGE SYS.DBMS_XDS
SYSPACKAGEKUPC$QUEUE_INTPREPARE_QUEUE_TABLEPACKAGE SYS.KUPV$FT_INT
SYSPACKAGEKUPC$QUEUE_INTSET_DEBUGPACKAGE SYS.KUPP$PROC
SYSPACKAGEKUPC$QUE_INTPREPARE_QUEUE_TABLEPACKAGE SYS.KUPC$QUEUE_INT
SYSPACKAGEKUPC$QUE_INTSET_DEBUGPACKAGE SYS.KUPC$QUEUE_INT
SYSPACKAGEKUPD$DATASET_DEBUGPACKAGE SYS.KUPP$PROC
SYSPACKAGEKUPD$DATA_INTGET_OPT_PARAMPACKAGE KUPD$DATA
SYSPACKAGEKUPF$FILEADD_DEVICEPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILEADD_FILEPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILEALLOCATE_DEVICEPACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILECHECK_FATAL_ERRORPACKAGE SYS.KUPD$DATA
SYSPACKAGEKUPF$FILECLOSE_CONTEXTPACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILEDELETE_UNUSED_FILE_REFSPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILEFILE_REQUESTPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILEFILE_REQUEST_NAKPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILEFLUSH_LOBPACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILEGET_BLKBUF_SIZESPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILEGET_DEFAULT_FILENAMEPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILEGET_DUMPFILE_INFOPACKAGE SYS.DBMS_DATAPUMP
SYSPACKAGEKUPF$FILEGET_FILE_LISTPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILEGET_FORMATTED_TIMEPACKAGE SYS.DBMS_DATAPUMP, PACKAGE SYS.DBMS_DATAPUMP_INT, PACKAGE SYS.DBMS_DATAPUMP_UTL, PACKAGE SYS.DBMS_METADATA, PACKAGE SYS.DBMS_METADATA_INT, PACKAGE SYS.DBMS_METADATA_UTIL, PACKAGE SYS.KUPC$QUEUE_INT, PACKAGE SYS.KUPC$QUE_INT, PACKAGE SYS.KUPD$DATA, PACKAGE SYS.KUPD$DATA_INT, PACKAGE SYS.KUPM$MCP, PACKAGE SYS.KUPP$PROC, PACKAGE SYS.KUPU$UTILITIES, PACKAGE SYS.KUPU$UTILITIES_INT, PACKAGE SYS.KUPV$FT, PACKAGE SYS.KUPV$FT_INT, PACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILEGET_FULL_FILENAMEPACKAGE SYS.DBMS_DATAPUMP, PACKAGE SYS.DBMS_DATAPUMP_INT, PACKAGE SYS.DBMS_DATAPUMP_UTL
SYSPACKAGEKUPF$FILEGET_MAX_CSWIDTHPACKAGE SYS.DBMS_DATAPUMP, PACKAGE SYS.DBMS_DATAPUMP_INT, PACKAGE SYS.DBMS_DATAPUMP_UTL, PACKAGE SYS.DBMS_METADATA, PACKAGE SYS.DBMS_METADATA_INT, PACKAGE SYS.DBMS_METADATA_UTIL, PACKAGE SYS.KUPC$QUEUE_INT, PACKAGE SYS.KUPC$QUE_INT, PACKAGE SYS.KUPD$DATA, PACKAGE SYS.KUPD$DATA_INT, PACKAGE SYS.KUPM$MCP, PACKAGE SYS.KUPP$PROC, PACKAGE SYS.KUPU$UTILITIES, PACKAGE SYS.KUPU$UTILITIES_INT, PACKAGE SYS.KUPV$FT, PACKAGE SYS.KUPV$FT_INT, PACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILEINITPACKAGE SYS.KUPM$MCP, PACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILEINIT_TDX_STATSPACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILEIS_DUMPFILE_SET_CONSISTENTPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILEJOB_MODESPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILELOCATE_MASTERPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILEMARK_FILES_AS_UNUSABLEPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILEMASTER_TABLE_UNLOAD_STARTEDPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILEOPEN_CONTEXTPACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILEREAD_LOBPACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILERELEASE_FILESPACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILERESET_EOFPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILESET_DEBUGPACKAGE SYS.KUPP$PROC
SYSPACKAGEKUPF$FILETERMPACKAGE SYS.KUPM$MCP, PACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILETRACEPACKAGE SYS.DBMS_DATAPUMP, PACKAGE SYS.DBMS_DATAPUMP_INT, PACKAGE SYS.DBMS_DATAPUMP_UTL, PACKAGE SYS.DBMS_METADATA, PACKAGE SYS.DBMS_METADATA_INT, PACKAGE SYS.DBMS_METADATA_UTIL, PACKAGE SYS.DBMS_PLUGTS, PACKAGE SYS.DBMS_TTS, PACKAGE SYS.KUPC$QUEUE_INT, PACKAGE SYS.KUPC$QUE_INT, PACKAGE SYS.KUPD$DATA, PACKAGE SYS.KUPD$DATA_INT, PACKAGE SYS.KUPM$MCP, PACKAGE SYS.KUPP$PROC, PACKAGE SYS.KUPU$UTILITIES, PACKAGE SYS.KUPU$UTILITIES_INT, PACKAGE SYS.KUPV$FT, PACKAGE SYS.KUPV$FT_INT, PACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILEVERIFY_DUMPFILE_SETPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILEWRITE_LOBPACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILE_INTCLOSE_CONTEXTPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTCREATE_DUMP_FILEPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTCREATE_KEY_INFOPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILE_INTDELETE_DUMP_FILEPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTENCODE_PWDPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILE_INTEXAMINE_DUMP_FILEPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTFLUSH_LOBPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTGET_BLKBUF_SIZESPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTGET_DEBUG_EVENTPACKAGE SYS.KUPF$FILE, PACKAGE SYS.UTL_XML
SYSPACKAGEKUPF$FILE_INTGET_DEFAULT_CREDENTIALPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILE_INTGET_DEFAULT_FILENAMEPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTGET_ENCODED_PWDPACKAGE SYS.KUPF$FILE, PACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILE_INTGET_FORMATTED_TIMEPACKAGE SYS.DBMS_DATAPUMP, PACKAGE SYS.DBMS_DATAPUMP_INT, PACKAGE SYS.DBMS_DATAPUMP_UTL, PACKAGE SYS.DBMS_METADATA, PACKAGE SYS.DBMS_METADATA_INT, PACKAGE SYS.DBMS_METADATA_UTIL, PACKAGE SYS.KUPC$QUEUE_INT, PACKAGE SYS.KUPC$QUE_INT, PACKAGE SYS.KUPD$DATA, PACKAGE SYS.KUPD$DATA_INT, PACKAGE SYS.KUPF$FILE, PACKAGE SYS.KUPM$MCP, PACKAGE SYS.KUPP$PROC, PACKAGE SYS.KUPU$UTILITIES, PACKAGE SYS.KUPU$UTILITIES_INT, PACKAGE SYS.KUPV$FT, PACKAGE SYS.KUPV$FT_INT, PACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILE_INTGET_FULL_FILENAMEPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTGET_MAX_CSWIDTHPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTGTOPPACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPF$FILE_INTINITPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTIS_DUMPFILE_A_RESTFILEPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILE_INTOPEN_CONTEXTPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTPARSE_FILENAMEPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTREAD_LOBPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTRELEASE_FILESPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTSET_DEBUGPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTSET_TRANS_PARAMSPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTTERMPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPF$FILE_INTVERIFY_KEY_INFOPACKAGE SYS.KUPF$FILE, PACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPF$FILE_INTWRITE_LOBPACKAGE SYS.KUPF$FILE
SYSPACKAGEKUPM$MCPCLOSE_JOBPACKAGE SYS.DBMS_DATAPUMP
SYSPACKAGEKUPM$MCPDISPATCHPACKAGE SYS.KUPC$QUEUE
SYSPACKAGEKUPM$MCPSET_DEBUGPACKAGE SYS.KUPP$PROC
SYSPACKAGEKUPP$PROCCREATE_MASTER_PROCESSPACKAGE SYS.KUPV$FT
SYSPACKAGEKUPP$PROCCREATE_WORKER_PROCESSESPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPU$UTILITIESGET_REMOTE_DBLINK_USERPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPU$UTILITIESREPLACE_XML_VALUESPACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPU$UTILITIES_INTCHECK_TBS_FOR_TDECOL_TABSPACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPU$UTILITIES_INTCREATE_DIRECTORYPACKAGE SYS.DBMS_DATAPUMP_UTL
SYSPACKAGEKUPU$UTILITIES_INTDEBUGPACKAGE SYS.KUPU$UTILITIES
SYSPACKAGEKUPU$UTILITIES_INTDIRECTORY_SCANPACKAGE SYS.DBMS_PLUGTS, PACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPU$UTILITIES_INTGET_DP_UPDATE_LOCKPACKAGE SYS.DBMS_METADATA, PACKAGE SYS.DBMS_METADATA_DIFF, PACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPU$UTILITIES_INTGET_PARAMETER_VALUEPACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPU$UTILITIES_INTGET_REMOTE_DBLINK_USERPACKAGE SYS.KUPU$UTILITIES
SYSPACKAGEKUPU$UTILITIES_INTINTALGCONVPACKAGE SYS.DBMS_METADATA_UTIL, PACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPU$UTILITIES_INTRELEASE_DP_UPDATE_LOCKPACKAGE SYS.DBMS_METADATA, PACKAGE SYS.DBMS_METADATA_DIFF, PACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPU$UTILITIES_INTSET_DEBUGPACKAGE SYS.KUPP$PROC
SYSPACKAGEKUPV$FTATTACH_JOBPACKAGE SYS.DBMS_DATAPUMP, PACKAGE SYS.KUPM$MCP, PACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPV$FTOPEN_JOBPACKAGE SYS.DBMS_DATAPUMP
SYSPACKAGEKUPV$FT_INTACTIVE_CLIENT_COUNTPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPV$FT_INTBUILD_MTABLE_INDEXESPACKAGE SYS.KUPM$MCP
SYSPACKAGEKUPV$FT_INTCREATE_NEW_JOBPACKAGE SYS.KUPV$FT
SYSPACKAGEKUPV$FT_INTDEBUG_ENABLEDPACKAGE SYS.KUPV$FT
SYSPACKAGEKUPV$FT_INTGET_DEBUG_INFOPACKAGE SYS.KUPV$FT
SYSPACKAGEKUPV$FT_INTON_BEHALFPACKAGE SYS.KUPV$FT
SYSPACKAGEKUPV$FT_INTSET_DEBUGPACKAGE SYS.KUPP$PROC
SYSPACKAGEKUPV$FT_INTSET_EVENTPACKAGE SYS.KUPC$QUE_INT, PACKAGE SYS.KUPD$DATA, PACKAGE SYS.KUPP$PROC, PACKAGE SYS.KUPW$WORKER
SYSPACKAGEKUPW$WORKERSET_DEBUGPACKAGE SYS.KUPP$PROC
SYSPACKAGEOUTLN_PKG_INTERNALPACKAGE SYS.OUTLN_PKG
SYSPACKAGEPRVT_ACCESS_ADVISORSETUP_USERPACKAGE PRVT_ADVISOR
SYSPACKAGEUTL_XMLPARSEEXPRPACKAGE SYS.DBMS_METADATA
SYSPACKAGEUTL_XMLPARSEQUERYPACKAGE SYS.DBMS_METADATA
SYSPACKAGEWWV_DBMS_SQL_APEX_050100APEX_050100.WWV_FLOW_DYNAMIC_EXEC, APEX_050100.WWV_FLOW_SESSION_RAS, APEX_050100.WWV_FLOW_UPGRADE
SYSPACKAGEXS_DATA_SECURITY_UTIL_INTPACKAGE XS_DATA_SECURITY_UTIL
SYSPROCEDUREEXECASUSERPACKAGE GGSYS.GGSHARDING, PACKAGE GSMADMIN_INTERNAL.DBMS_GSM_CLOUDADMIN, PACKAGE GSMADMIN_INTERNAL.DBMS_GSM_COMMON, PACKAGE GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN, PACKAGE GSMADMIN_INTERNAL.DBMS_GSM_POOLADMIN, PACKAGE GSMADMIN_INTERNAL.DBMS_GSM_UTILITY, PROCEDURE GSMADMIN_INTERNAL.EXECUTEDDL
WMSYSPACKAGELTADMPACKAGE OWM_IEXP_PKG, PACKAGE WMSYS.LT, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTPRIV, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.LT_CTX_PKG, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_DML_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.OWM_MP_PKG, PACKAGE WMSYS.UD_TRIGS, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTAQPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM
WMSYSPACKAGELTDDLPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTDTRGPACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.UD_TRIGS, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTPRIVPACKAGE WMSYS.LT
WMSYSPACKAGELTRICGETVARIABLE_CPACKAGE WMSYS.OWM_DYNSQL_ACCESS
WMSYSPACKAGELTRICSETVARIABLEPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM
WMSYSPACKAGELTRICPACKAGE OWM_MP_PKG, PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.UD_TRIGS, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILADDUSERDEFINEDHINTPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILADDWCPPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILALLOCATE_UNIQUEPACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILALLOWROWLEVELLOCKINGPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILCHECKADDTOPOGEOLAYERERRORSPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILCHECKDELTOPOGEOLAYERERRORSPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILCHECKDOMAININDEXPRIVSPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILCLEANUPBDDLPACKAGE WMSYS.OWM_DDL_PKG
WMSYSPACKAGELTUTILCLEANUPCDDLPACKAGE WMSYS.OWM_DDL_PKG
WMSYSPACKAGELTUTILCLEANUPDVPACKAGE WMSYS.LTDDL
WMSYSPACKAGELTUTILCLEANUPEVPACKAGE WMSYS.LTDDL
WMSYSPACKAGELTUTILCLEANUPMETADATAPACKAGE WMSYS.LTDDL
WMSYSPACKAGELTUTILCLEANUPMETADATABYUSERPACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_DYNSQL_ACCESS
WMSYSPACKAGELTUTILCLEANUPSTALEMETADATAPACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS
WMSYSPACKAGELTUTILCREATEINLISTFROMQUERYPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILCREATEPKWHERECLAUSEPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC
WMSYSPACKAGELTUTILDELETEFULLROLLBACKMARKERPACKAGE WMSYS.LT_CTX_PKG
WMSYSPACKAGELTUTILDELETEUNDOCODEPACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DDL_PKG
WMSYSPACKAGELTUTILDELETEUNDOCODECHECKPOINTSPACKAGE WMSYS.LT_CTX_PKG
WMSYSPACKAGELTUTILDELETEUNDOCODERANGEPACKAGE WMSYS.LTDDL
WMSYSPACKAGELTUTILDISALLOWIFWITHVTPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILEXECEVUNDOPACKAGE WMSYS.LTDDL
WMSYSPACKAGELTUTILEXECLOGPACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILEXECUTESQLLOGPACKAGE WMSYS.LT, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_MIG_PKG
WMSYSPACKAGELTUTILEXISTSBIRPACKAGE WMSYS.LTRIC
WMSYSPACKAGELTUTILEXISTSBURPACKAGE WMSYS.LTRIC
WMSYSPACKAGELTUTILEXISTSCONSTRAINTPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILEXISTSFULLROLLBACKMARKERPACKAGE WMSYS.LTDDL
WMSYSPACKAGELTUTILEXISTSTOPOLOGYPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILFIXTOPOLOGYIMPORTPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILFIXVTAB_COMPRESSPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILFIXVTAB_REFRESHPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILFIXVTAB_ROLLBACKPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILGENFIXCRNONSEQNFRESHINSPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILGENWMCOLSUPDATESTMNTPACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETBASETABLENAMEPACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETBATCHWHERECLAUSESPACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_DYNSQL_ACCESS
WMSYSPACKAGELTUTILGETCOLINFOPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_IEXP_PKG
WMSYSPACKAGELTUTILGETCOLLISTPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILGETCOLSTRPACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.UD_TRIGS, PACKAGE WMSYS.WM_DDL_UTIL, WMSYS.OWM_MIG_PKG
WMSYSPACKAGELTUTILGETCOLUMNPLUSEXPRESSIONPACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETCRSTATUSPACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_BULK_LOAD_PKG
WMSYSPACKAGELTUTILGETCURRENTLOCKINGMODEPACKAGE WMSYS.LT_CTX_PKG
WMSYSPACKAGELTUTILGETCURVERPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_IEXP_PKG
WMSYSPACKAGELTUTILGETDISTINCTOBJECTPACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETDISVERPACKAGE WMSYS.LT, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETHISTOPTIONPACKAGE OWM_IEXP_PKG, PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETINDEXTABLEPACKAGE WMSYS.LT, PACKAGE WMSYS.LTDTRG
WMSYSPACKAGELTUTILGETINDEXTABLESPACEPACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETNESTEDCOLUMNVIEWPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETNESTEDTABLECOLSTRPACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETNESTEDTABLEMETADATACOLUMNSPACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETNESTEDTABLETYPEPACKAGE WMSYS.OWM_DDL_PKG
WMSYSPACKAGELTUTILGETNEXTVERSIONPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILGETNOTNULLCONSTRAINTPACKAGE WMSYS.OWM_DDL_PKG
WMSYSPACKAGELTUTILGETNTPKEYCOLSPACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_MP_PKG
WMSYSPACKAGELTUTILGETPKEYINFOPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILGETPKEYINFO_VTPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILGETPKINDEXINFOPACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETRLSWHERECLAUSEPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILGETSEQUENCEOPTIONSPACKAGE WMSYS.OWM_DDL_PKG
WMSYSPACKAGELTUTILGETSIDPACKAGE WMSYS.LTADM, PACKAGE WMSYS.LT_CTX_PKG
WMSYSPACKAGELTUTILGETSNOPACKAGE WMSYS.LT_CTX_PKG
WMSYSPACKAGELTUTILGETSPACEUSAGEPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILGETTABLETABLESPACEPACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_DDL_PKG, WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETTOPOFEATURETABINFOPACKAGE WMSYS.LTDTRG
WMSYSPACKAGELTUTILGETTOPOINFOPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILGETTRIGGERSPACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG
WMSYSPACKAGELTUTILGETUDHINTPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETUNDOCODECLOBPACKAGE WMSYS.OWM_BULK_LOAD_PKG
WMSYSPACKAGELTUTILGETVALIDTIMEOPTIONPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.OWM_MP_PKG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETVARIABLE_RPACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETVERINDEXNAMEPACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.OWM_MP_PKG
WMSYSPACKAGELTUTILGETVTIDPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.WM_DDL_UTIL, TRIGGER WMSYS.WM$BCT_I_TRIG, TRIGGER WMSYS.WM$CC_I_TRIG, TRIGGER WMSYS.WM$CP_D_TRIG, TRIGGER WMSYS.WM$CP_I_TRIG, TRIGGER WMSYS.WM$CP_U_TRIG, TRIGGER WMSYS.WM$CT_I_TRIG, TRIGGER WMSYS.WM$CT_U_TRIG, TRIGGER WMSYS.WM$HT_I_TRIG, TRIGGER WMSYS.WM$LI_I_TRIG, TRIGGER WMSYS.WM$MT_I_TRIG, TRIGGER WMSYS.WM$NCT_I_TRIG, TRIGGER WMSYS.WM$RLT_I_TRIG, TRIGGER WMSYS.WM$RTT_I_TRIG, TRIGGER WMSYS.WM$RT_D_TRIG, TRIGGER WMSYS.WM$RT_I_TRIG, TRIGGER WMSYS.WM$UDP_I_TRIG, TRIGGER WMSYS.WM$UD_U_TRIG, TRIGGER WMSYS.WM$UI_I_TRIG, TRIGGER WMSYS.WM$VET_I_TRIG, TRIGGER WMSYS.WM$VET_U_TRIG
WMSYSPACKAGELTUTILGETWHERECLAUSESTRPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.OWM_MP_PKG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILGETWORKSPACELOCKIDPACKAGE WMSYS.LTADM, TRIGGER WMSYS.WM$BCT_I_TRIG, TRIGGER WMSYS.WM$LI_I_TRIG, TRIGGER WMSYS.WM$MGWT_I_TRIG, TRIGGER WMSYS.WM$MPWT_I_TRIG, TRIGGER WMSYS.WM$MT_I_TRIG, TRIGGER WMSYS.WM$MW_I_TRIG, TRIGGER WMSYS.WM$NT_I_TRIG, TRIGGER WMSYS.WM$RWT_I_TRIG, TRIGGER WMSYS.WM$VHT_I_TRIG, TRIGGER WMSYS.WM$VT_I_TRIG, TRIGGER WMSYS.WM$WPT_D_TRIG, TRIGGER WMSYS.WM$WPT_I_TRIG, TRIGGER WMSYS.WM$WPT_U_TRIG, TRIGGER WMSYS.WM$WST_I_TRIG, TRIGGER WMSYS.WM$WT_I_TRIG, WMSYS.LT_CTX_PKG
WMSYSPACKAGELTUTILGETWORKSPACELOCKMODEPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILGET_EXPANDED_NEXTVERS_NPPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILGRANTOLSPRIVSPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILHASCRCHILDPACKAGE WMSYS.LT, PACKAGE WMSYS.LTRIC
WMSYSPACKAGELTUTILHASDEFERREDCHILDPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILHASFEATURETABLEPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILHASNESTEDTABLECOLUMNPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILHASOLSPOLICYPACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILHASRICCASCADINGCONSTRAINTPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILHASRICSETNULLCONSTRAINTPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILHASVIRTUALCOLUMNPACKAGE WMSYS.LTDTRG
WMSYSPACKAGELTUTILHASWOOVERWRITEOPTIONPACKAGE WMSYS.LT, PACKAGE WMSYS.LTRIC
WMSYSPACKAGELTUTILHISTWITHDATETYPEPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG
WMSYSPACKAGELTUTILHISTWITHDATETYPEEVPACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILINSERTFULLROLLBACKMARKERPACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LT_CTX_PKG
WMSYSPACKAGELTUTILINVERSIONEDSTATEPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILISIMPLICITSPPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILISLEAFSTATEPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILISMODIFIEDPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILISMODIFIEDINSUBTREEPACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_DYNSQL_ACCESS
WMSYSPACKAGELTUTILISOBJECTTABLEPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILISSPATIALINSTALLEDPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_MIG_PKG
WMSYSPACKAGELTUTILISSPLITINSUBTREEPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILISTOPOFEATURETABLEPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG
WMSYSPACKAGELTUTILISTOPOLOGYINDEXTABLEPACKAGE WMSYS.LT, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LT_EXPORT_PKG
WMSYSPACKAGELTUTILISTOPOLOGYRELATIONTABLEPACKAGE WMSYS.LTDTRG
WMSYSPACKAGELTUTILISVERSIONEDTABLEPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILISVERSIONENABLEDTOPOLOGYPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILISWORKSPACEOWNERPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILMOVEWMMETADATAPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILNEEDTOEXECUTETRIGGERSPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILNUMTRIGGERSTOEXECUTEPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILPARSESTRINGLISTPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILPOPULATEROWIDRANGESPACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILPREFIXSTRPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILQB_BLOCK_REPLACEPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILREMOVEUSERDEFINEDHINTPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILRENAMESAVEPOINTPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILRENAMEWORKSPACEPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILREQUIRESTRIGGERSONTOPVIEWPACKAGE WMSYS.LTDTRG
WMSYSPACKAGELTUTILRESETALLSEQUENCESPACKAGE WMSYS.LT_EXPORT_PKG
WMSYSPACKAGELTUTILRESOLVESYNONYMPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC
WMSYSPACKAGELTUTILRESTARTSEQUENCEPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILSEPARATECLOBINTO2PARTSPACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILSETVARIABLEPACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELTUTILTOPOTABLECHECKPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILTO_CLOB_PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM
WMSYSPACKAGELTUTILUPDATESDOTOPOMETADATADVPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILUPDATESDOTOPOMETADATAEVPACKAGE WMSYS.LT
WMSYSPACKAGELTUTILWM$GETDBCOMPATIBLESTRPACKAGE WMSYS.OWM_IEXP_PKG
WMSYSPACKAGELTUTILWRITETOLOGPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.OWM_MP_PKG, PACKAGE WMSYS.UD_TRIGS, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELT_CTX_PKGALLOWDDLOPERATIONPACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS
WMSYSPACKAGELT_CTX_PKGCHVLTLPACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELT_CTX_PKGGETLTTABLENAMEWMSYS.LTDTRG
WMSYSPACKAGELT_CTX_PKGGETMULTIWORKSPACESWMSYS.LT
WMSYSPACKAGELT_CTX_PKGGETPURGEOPTIONPACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGELT_CTX_PKGGETSESSIONATTRIBUTESPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LT_EXPORT_PKG
WMSYSPACKAGELT_CTX_PKGGETVARIABLE_BPACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS
WMSYSPACKAGELT_CTX_PKGGETVARIABLE_NPACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.OWM_DYNSQL_ACCESS
WMSYSPACKAGELT_CTX_PKGGETVARIABLE_VPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTAQ, PACKAGE WMSYS.LTUTIL
WMSYSPACKAGELT_CTX_PKGGETVTTABLENAMEWMSYS.LTDTRG
WMSYSPACKAGELT_CTX_PKGSETACTIVETIMEFORDMLWMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETCALLSTACKASINVALIDPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG
WMSYSPACKAGELT_CTX_PKGSETCALLSTACKASVALIDPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG
WMSYSPACKAGELT_CTX_PKGSETCOMMITVARSWMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETCOMPRESSWORKSPACEPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETCONFLICTSTATEPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETCOPYVARSPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETDIFFVERSPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETFLIPVERSIONONREFRESHPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETFREEZESTATUSPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM
WMSYSPACKAGELT_CTX_PKGSETIMPORTVARSPACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_DYNSQL_ACCESS
WMSYSPACKAGELT_CTX_PKGSETINSTANTPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_IEXP_PKG
WMSYSPACKAGELT_CTX_PKGSETLOCKMODEPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETMPROOTPACKAGE WMSYS.OWM_MP_PKG
WMSYSPACKAGELT_CTX_PKGSETMPWORKSPACEPACKAGE WMSYS.OWM_MP_PKG
WMSYSPACKAGELT_CTX_PKGSETMULTIWORKSPACESPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETNEWMPVARSPACKAGE WMSYS.OWM_MP_PKG
WMSYSPACKAGELT_CTX_PKGSETNEWROOTANCVERSIONPACKAGE WMSYS.OWM_MP_PKG
WMSYSPACKAGELT_CTX_PKGSETOPCONTEXTPACKAGE WMSYS.LTUTIL
WMSYSPACKAGELT_CTX_PKGSETPOSTVARSPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETROWLOCKSTATUSPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETSAVEPOINTPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM
WMSYSPACKAGELT_CTX_PKGSETSTATEATTRIBUTESPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETTABMRGWOREMOVEEVENTPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETTABMRGWREMOVEEVENTPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETTABREFRESHEVENTPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETTRIGGEREVENTPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETTSINSTANTPACKAGE WMSYS.LTADM
WMSYSPACKAGELT_CTX_PKGSETUSERPACKAGE WMSYS.LTPRIV
WMSYSPACKAGELT_CTX_PKGSETVALIDTIMEPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETVALIDTIMEFILTEROFFPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETVALIDTIMEFILTERONPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETVARIABLEPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.OWM_IEXP_PKG
WMSYSPACKAGELT_CTX_PKGSETVERAFTINSTANTPACKAGE WMSYS.LTADM
WMSYSPACKAGELT_CTX_PKGSETVERBEFINSTANTPACKAGE WMSYS.LTADM
WMSYSPACKAGELT_CTX_PKGSETVERSIONPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_IEXP_PKG
WMSYSPACKAGELT_CTX_PKGSETVERSIONANDSTATEPACKAGE WMSYS.OWM_IEXP_PKG
WMSYSPACKAGELT_CTX_PKGSETWRITERSTATEPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETWSPCMRGWOREMOVEEVENTPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGSETWSPCMRGWREMOVEEVENTPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGTO_TIMESTAMP_TZ_PACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGUNSETCOMMITVARSPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGUNSETCOPYVARSPACKAGE WMSYS.LT
WMSYSPACKAGELT_CTX_PKGUNSETIMPORTVARSPACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_DYNSQL_ACCESS
WMSYSPACKAGELT_CTX_PKGUNSETPOSTVARSPACKAGE WMSYS.LT
WMSYSPACKAGELT_EXPORT_PKGEXPORT_SCHEMASPACKAGE WMSYS.LT
WMSYSPACKAGEOWM_ASSERT_PKGPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_CPKG_PKG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.OWM_MP_PKG, PACKAGE WMSYS.OWM_VSCRIPT_PKG, PACKAGE WMSYS.UD_TRIGS, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGEOWM_BULK_LOAD_PKGPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_DYNSQL_ACCESS
WMSYSPACKAGEOWM_CPKG_PKGPACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG
WMSYSPACKAGEOWM_DDL_PKGPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.OWM_MP_PKG, PACKAGE WMSYS.UD_TRIGS, PACKAGE WMSYS.WM_DDL_UTIL
WMSYSPACKAGEOWM_DML_PKGTRIGGER WMSYS.WM$CP_I_TRIG, TRIGGER WMSYS.WM$CP_U_TRIG, TRIGGER WMSYS.WM$CT_I_TRIG, TRIGGER WMSYS.WM$CT_U_TRIG, TRIGGER WMSYS.WM$EI_I_TRIG, TRIGGER WMSYS.WM$EI_U_TRIG, TRIGGER WMSYS.WM$EV_I_TRIG, TRIGGER WMSYS.WM$HT_I_TRIG, TRIGGER WMSYS.WM$MGWT_I_TRIG, TRIGGER WMSYS.WM$MPWT_I_TRIG, TRIGGER WMSYS.WM$RT_I_TRIG, TRIGGER WMSYS.WM$RWT_I_TRIG, TRIGGER WMSYS.WM$SAV_I_TRIG, TRIGGER WMSYS.WM$UDP_I_TRIG, TRIGGER WMSYS.WM$UD_U_TRIG, TRIGGER WMSYS.WM$UI_I_TRIG, TRIGGER WMSYS.WM$VET_I_TRIG, TRIGGER WMSYS.WM$VET_U_TRIG, TRIGGER WMSYS.WM$VTH_I_TRIG, TRIGGER WMSYS.WM$VTH_U_TRIG, TRIGGER WMSYS.WM$WPT_D_TRIG, TRIGGER WMSYS.WM$WPT_I_TRIG, TRIGGER WMSYS.WM$WPT_U_TRIG, TRIGGER WMSYS.WM$WST_I_TRIG, TRIGGER WMSYS.WM$WT_I_TRIG, TRIGGER WMSYS.WM$WT_U_TRIG
WMSYSPACKAGEOWM_IEXP_PKGPACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_DYNSQL_ACCESS
WMSYSPACKAGEOWM_MIG_PKGRECOVERMIGRATINGTABLEPACKAGE WMSYS.LT
WMSYSPACKAGEOWM_MP_PKGPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTPRIV, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS
WMSYSPACKAGEOWM_VSCRIPT_PKGSTARTQUEUEPACKAGE WMSYS.LT_EXPORT_PKG
WMSYSPACKAGEOWM_VSCRIPT_PKGSTOPQUEUEPACKAGE WMSYS.LT_EXPORT_PKG
WMSYSPACKAGEOWM_VSCRIPT_PKGWM$CONVERTVERSIONSTRPACKAGE WMSYS.LTUTIL
WMSYSPACKAGEOWM_VSCRIPT_PKGWM$GETDBPARAMETERPACKAGE WMSYS.LT_CTX_PKG
WMSYSPACKAGEUD_TRIGSPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_DML_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG
WMSYSPACKAGEWM_DDL_UTILPACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.OWM_MIG_PKG
XDBPACKAGEDBMS_CLOBUTILPACKAGE XDB.DBMS_XMLDOM, PACKAGE XDB.DBMS_XMLPARSER, PACKAGE XDB.DBMS_XSLPROCESSOR
XDBPACKAGEDBMS_JSON_INTPACKAGE XDB.DBMS_JSON
XDBPACKAGEDBMS_SODA_DMLPACKAGE XDB.DBMS_SODA_ADMIN

Updated on 2018-05-01: amended query to produce no subprogram name for standalone procedures and functions (was SYS in two cases); included complete query (procedure_accessors.sql); updated result table.

Updated on 2018-05-02: amended query to improve multi-line comments and string literals handling (thanks to Jacek Gębal)

Leave a Reply

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