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.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
-- PARSEQUERY: Parse a SQL query and return in a CLOB as XML -- PARAMS: -- currUid - UID of current user -- schema - schem to use for parse -- sqltext - the text of the query -- lobloc - a LOB locator to receive the parsed value PROCEDURE parseQuery (currUid IN NUMBER, schema IN VARCHAR2, sqltext IN CLOB, lobloc IN OUT NOCOPY CLOB ) ACCESSIBLE BY (PACKAGE SYS.DBMS_METADATA); |
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 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.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 |
WITH -- -- remove multi-line comments from source -- FUNCTION remove_ml_comments (in_source IN CLOB) RETURN CLOB IS BEGIN RETURN regexp_replace(in_source, '/\*.*?\*/', NULL, 1, 0, 'n'); END remove_ml_comments; -- -- remove single-line comments from source -- FUNCTION remove_sl_comments (in_source IN CLOB) RETURN CLOB IS BEGIN RETURN regexp_replace(in_source, '--.*'); END remove_sl_comments; -- -- remove simple string literals from source -- FUNCTION remove_simple_string_literals (in_source IN CLOB) RETURN CLOB IS BEGIN RETURN regexp_replace(in_source, q'['.*?']', NULL, 1, 0, 'n'); END remove_simple_string_literals; -- -- remove quoted string literals from source -- supporting the following quote_delimiter pairs only: (), {}, [], <>, $$, ##, @@, ££, "", //, ||, !!, ++, ~~ -- FUNCTION remove_quoted_string_literals ( in_source IN CLOB ) RETURN CLOB IS co_pattern CONSTANT VARCHAR2(200) := q'[n?q'((\(.*?\))|(\{.*?\})|(\[.*?\])|(<.*?>)|(\$.*?\$)|(#.*?#)|(@.*?@)|(£.*?£)|(".*?")|(/.*?/)|(\|.*?\|)|(!.*?!)|(\+.*?\+)|(~.*?~))']'; BEGIN RETURN regexp_replace(in_source, co_pattern, NULL, 1, 0, 'in'); END remove_quoted_string_literals; -- -- remove all string literals and comments from source -- FUNCTION remove_all (in_source IN CLOB) RETURN CLOB IS l_clob CLOB := in_source; BEGIN l_clob := remove_sl_comments(l_clob); l_clob := remove_quoted_string_literals(l_clob); l_clob := remove_simple_string_literals(l_clob); l_clob := remove_ml_comments(l_clob); return l_clob; END remove_all; -- -- get subprogram associated with the accessible_by_clause in JSON format, e.g. -- { -- "id": 5, -- "type": "PROCEDURE", -- "name": "parseQuery", -- } -- -- return NULL if accessible_by_clause is for the PL/SQL unit -- FUNCTION get_subprogram( in_object_type VARCHAR2, in_source CLOB, in_pos INTEGER ) RETURN VARCHAR2 IS l_subprogram json_object_t; co_pattern CONSTANT VARCHAR2(100 CHAR) := '(function|procedure)(\s+)("?[a-zA-Z0-9_#$]+"?)'; l_source CLOB; l_count INTEGER; l_match VARCHAR2(4000 CHAR); BEGIN l_subprogram := json_object_t(); IF in_object_type NOT IN ('FUNCTION', 'PROCEDURE') THEN l_source := regexp_replace(substr(in_source, 1, in_pos - 1), 'accessible\s+by\s*\(.*?\)', NULL, 1, 0, 'in'); l_count := regexp_count(l_source, co_pattern, 1, 'in'); IF l_count > 0 THEN l_match := regexp_substr(l_source, co_pattern, 1, l_count, 'in'); l_subprogram.put('id', l_count); l_subprogram.put('type', regexp_substr(l_match, co_pattern, 1, 1, 'in', 1)); l_subprogram.put('name', regexp_substr(l_match, co_pattern, 1, 1, 'in', 3)); END IF; END IF; RETURN l_subprogram.to_string(); END get_subprogram; -- -- get the list of subprograms and its accessors as JSON array, e.g. -- [ -- { -- "id": 5, -- "type": "PROCEDURE", -- "name": "parseQuery", -- "accessors": [ -- { -- "unit_kind": "PACKAGE", -- "schema": "SYS", -- "unit_name": "DBMS_METADATA" -- } -- ] -- } -- ] -- FUNCTION get_accessors( in_object_type VARCHAR2, in_source CLOB, in_accessible_by_count INTEGER ) RETURN CLOB IS co_full_clause_pattern CONSTANT VARCHAR2(100 CHAR) := 'accessible\s+by\s*\(.*?\)'; co_accessor_pattern CONSTANT VARCHAR2(200 CHAR) := '(\(|,)(\s*)(function|procedure|package|trigger|type)?(\s*)("?[a-zA-Z0-9_#$]+"?\s*\.)?("?[a-zA-Z0-9_#$]+"?)'; l_subprograms json_array_t; l_subprogram json_object_t; l_full_clause VARCHAR2(4000 CHAR); l_accessors json_array_t; l_accessor json_object_t; l_pos INTEGER; l_accessor_count INTEGER; BEGIN l_subprograms := json_array_t(); <<accessible_by_clauses>> FOR i in 1 .. in_accessible_by_count LOOP l_pos := regexp_instr(in_source, co_full_clause_pattern, 1, i, 0, 'in'); l_subprogram := json_object_t.parse(get_subprogram(in_object_type, in_source, l_pos)); l_full_clause := regexp_substr(in_source, co_full_clause_pattern, 1, i, 'in'); l_accessor_count := regexp_count(l_full_clause, co_accessor_pattern, 1, 'in'); l_accessors := json_array_t(); <<accessors>> FOR j in 1 .. l_accessor_count LOOP l_accessor := json_object_t(); l_accessor.put('unit_kind', regexp_substr(l_full_clause, co_accessor_pattern, 1, j, 'in', 3)); l_accessor.put('schema', replace(regexp_substr(l_full_clause, co_accessor_pattern, 1, j, 'in', 5),'.')); l_accessor.put('unit_name', regexp_substr(l_full_clause, co_accessor_pattern, 1, j, 'in', 6)); l_accessors.append(l_accessor); END LOOP accessors; l_subprogram.put('accessors', l_accessors); l_subprograms.append(l_subprogram); END LOOP accessible_by_clauses; return l_subprograms.to_clob(); END get_accessors; -- -- ensure identifier matches case sensitive name in Orace data dictionary -- FUNCTION fix_identifier (in_identifier IN VARCHAR2) RETURN VARCHAR2 IS l_identifier VARCHAR2(128 CHAR); BEGIN IF in_identifier LIKE '"%"' THEN l_identifier := substr(in_identifier, 2, length(in_identifier) - 2); ELSE l_identifier := upper(in_identifier); END IF; RETURN l_identifier; END fix_identifier; -- -- possible PL/SQL units with an accessible_by_clause (optimization step) -- false positives when keyword 'accessible' is not used in a accessible_by_clause -- candidates AS ( SELECT /*+ no_merge */ s.owner, s.type AS object_type, s.name AS object_name, u.oracle_maintained FROM dba_users u JOIN dba_source s ON u.username = s.owner WHERE s.type IN ('FUNCTION', 'PROCEDURE', 'PACKAGE', 'TYPE') AND lower(text) LIKE '%accessible%' GROUP BY s.owner, s.type, s.name, u.oracle_maintained ), -- -- extend result with source code (unmodified) -- original_sources AS ( SELECT owner, object_type, object_name, oracle_maintained, sys.dbms_metadata.get_ddl( schema => owner, object_type => CASE object_type WHEN 'PACKAGE' THEN 'PACKAGE_SPEC' WHEN 'TYPE' THEN 'TYPE_SPEC' ELSE object_type END, name => object_name ) AS source_code FROM candidates ), -- -- remove comments and string literals from source code to simplify parsing -- reduced_sources AS ( SELECT owner, object_type, object_name, oracle_maintained, remove_all(source_code) AS source_code FROM original_sources ), -- -- extend result with number of accessible_by_clauses in source -- counts AS ( SELECT owner, object_type, object_name, source_code, oracle_maintained, regexp_count(source_code, 'accessible\s+by\s*\(.*?\)', 1, 'in') accessible_by_count FROM reduced_sources ), -- -- produce a row for every accessor and extend results by accessor related columns -- procedure_accessors AS ( SELECT c.owner, c.object_type, c.object_name, c.oracle_maintained, upper(a.subprogram_type) AS subprogram_type, fix_identifier(a.subprogram_name) AS procedure_name, coalesce(a.subprogram_id, 0) AS subprogram_id, upper(a.accessor_unit_kind) AS accessor_unit_kind, fix_identifier(a.accessor_schema) AS accessor_schema, fix_identifier(a.accessor_unit_name) AS accessor_unit_name FROM counts c CROSS JOIN JSON_TABLE( get_accessors(c.object_type, c.source_code, c.accessible_by_count), '$[*]' columns ( subprogram_type VARCHAR2(30 CHAR) PATH '$.type', subprogram_name VARCHAR2(128 CHAR) PATH '$.name', subprogram_id INTEGER PATH '$.id', nested path '$.accessors[*]' columns ( accessor_unit_kind VARCHAR2(30 CHAR) PATH '$.unit_kind', accessor_schema VARCHAR2(128 CHAR) PATH '$.schema', accessor_unit_name VARCHAR2(128 CHAR) PATH '$.unit_name' ) ) ) a WHERE c.accessible_by_count > 0 ), -- -- produce compact accessor column, remove duplicates from overloaded subprograms -- aggr_procedure_accessors_base AS ( SELECT DISTINCT owner, object_type, object_name, procedure_name, accessor_unit_kind, accessor_schema, accessor_unit_name, CASE WHEN accessor_unit_kind IS NOT NULL THEN accessor_unit_kind || ' ' END || CASE WHEN accessor_schema IS NOT NULL THEN accessor_schema || '.' END || accessor_unit_name AS accessor, oracle_maintained FROM procedure_accessors ), -- -- aggregated result per subprogram with accessor_list containing comma separated list of all accessors -- aggr_procedure_accessors AS ( SELECT owner, object_type, object_name, procedure_name, listagg (accessor, ', ') WITHIN GROUP(ORDER BY accessor) AS accessor_list FROM aggr_procedure_accessors_base WHERE oracle_maintained = 'Y' GROUP BY owner, object_type, object_name, procedure_name ORDER BY owner, object_type, object_name, procedure_name ) -- main SELECT * FROM aggr_procedure_accessors / |
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.
| Owner | Object Type | Object Name | Procedure Name | Accessor List |
|---|---|---|---|---|
| APEX_050100 | PACKAGE | WWV_FLOW_ADVISOR_CHECKS_INT | WWV_FLOW_ADVISOR_CHECKS_API | |
| APEX_050100 | PACKAGE | WWV_FLOW_APP_INSTALL_INT | WWV_FLOW_IMP_PARSER, WWV_FLOW_PKG_APP_PARSER | |
| APEX_050100 | PACKAGE | WWV_FLOW_REGION_LIST | WWV_FLOW_REGION_NATIVE | |
| APEX_050100 | PACKAGE | WWV_FLOW_SPATIAL_INT | WWV_FLOW_SPATIAL_API | |
| CTXSYS | PACKAGE | DRIACCHELP | PACKAGE DRIACC | |
| CTXSYS | PACKAGE | DRIUTL | PARSE_OBJECT_NAME | PACKAGE DRVUTL, PROCEDURE PARSE_OBJECT_NAME |
| CTXSYS | PACKAGE | DRVODM | SVM_TRAIN | CTXSYS.CTX_CLS |
| DVSYS | PACKAGE | CONFIGURE_DV_INTERNAL | PROCEDURE SYS.CONFIGURE_DV | |
| GSMADMIN_INTERNAL | PACKAGE | DBMS_GSM_COMMON | GETDBPARAMETERNUM | PACKAGE 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_INTERNAL | PACKAGE | DBMS_GSM_COMMON | GETDBPARAMETERSTR | PACKAGE DBMS_GSM_CLOUDADMIN, PACKAGE DBMS_GSM_COMMON, PACKAGE DBMS_GSM_DBADMIN, PACKAGE DBMS_GSM_POOLADMIN, PACKAGE GGSYS.GGSHARDING |
| GSMADMIN_INTERNAL | PACKAGE | DBMS_GSM_COMMON | RESETDBPARAMETER | PACKAGE DBMS_GSM_CLOUDADMIN, PACKAGE DBMS_GSM_COMMON, PACKAGE DBMS_GSM_DBADMIN, PACKAGE DBMS_GSM_POOLADMIN, PACKAGE GGSYS.GGSHARDING |
| GSMADMIN_INTERNAL | PACKAGE | DBMS_GSM_COMMON | SETDBPARAMETER | PACKAGE DBMS_GSM_CLOUDADMIN, PACKAGE DBMS_GSM_COMMON, PACKAGE DBMS_GSM_DBADMIN, PACKAGE DBMS_GSM_POOLADMIN, PACKAGE GGSYS.GGSHARDING |
| GSMADMIN_INTERNAL | PACKAGE | DBMS_GSM_UTILITY | GENERATECHANGELOGENTRY | PACKAGE DBMS_GSM_CLOUDADMIN, PACKAGE DBMS_GSM_COMMON, PACKAGE DBMS_GSM_DBADMIN, PACKAGE DBMS_GSM_POOLADMIN, PACKAGE GGSYS.GGSHARDING |
| GSMADMIN_INTERNAL | PACKAGE | EXCHANGE | PACKAGE GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN, PACKAGE SYS.EXCH_TEST | |
| SYS | FUNCTION | ISXMLTYPETABLE_INTERNAL | ISXMLTYPETABLE | |
| SYS | PACKAGE | CDBVIEW_INTERNAL | PACKAGE SYS.CDBVIEW | |
| SYS | PACKAGE | DBMS_AQADM_INV | PACKAGE 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 | |
| SYS | PACKAGE | DBMS_AQADM_SYSCALLS | PACKAGE 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 | |
| SYS | PACKAGE | DBMS_AWR_PROTECTED | DBMS_AWR_REPORT_LAYOUT, DBMS_SWRF_REPORT_INTERNAL | |
| SYS | PACKAGE | DBMS_EXPORT_EXTENSION_I | PACKAGE SYS.DBMS_EXPORT_EXTENSION | |
| SYS | PACKAGE | DBMS_ISCHED_CHAIN_CONDITION | DELETE_STEP_NAME_TABLE | PACKAGE DBMS_ISCHED |
| SYS | PACKAGE | DBMS_JSON0 | PACKAGE XDB.DBMS_JSON | |
| SYS | PACKAGE | DBMS_METADATA_UTIL | SET_MARKER | PACKAGE SYS.DBMS_METADATA_INT |
| SYS | PACKAGE | DBMS_MVIEW_STATS_INTERNAL | DBMS_MVIEW_STATS | |
| SYS | PACKAGE | DBMS_PCLXUTIL_INTERNAL | PACKAGE SYS.DBMS_PCLXUTIL | |
| SYS | PACKAGE | DBMS_PLUGTS | PLTS_NEWDATAFILE | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | DBMS_RAT_MASK_INTERNAL | SYS.DBMS_RAT_MASK | |
| SYS | PACKAGE | DBMS_RECO_SCRIPT_INT | EXTENDED_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 | |
| SYS | PACKAGE | DBMS_RESULT_CACHE_INTERNAL | DBMS_NETWORK_ACL_ADMIN, RC_INTERNAL_TEST | |
| SYS | PACKAGE | DBMS_SNAPSHOT_KKXRCA | PACKAGE DBMS_SNAPSHOT | |
| SYS | PACKAGE | DBMS_SODA_UTIL | PACKAGE SYS.DBMS_SODA, PACKAGE XDB.DBMS_SODA_ADMIN, PACKAGE XDB.DBMS_SODA_DML, PACKAGE XDB.DBMS_SODA_DOM | |
| SYS | PACKAGE | DBMS_SQLTUNE_INTERNAL | EXEC_EMX_TUNING_TASK_CALLOUT | TYPE SYS.WRI$_REPT_SQLT |
| SYS | PACKAGE | DBMS_SQLTUNE_INTERNAL | I_PROCESS_SQL | PACKAGE SYS.DBMS_SQLDIAG, PACKAGE SYS.DBMS_SQLTCB_INTERNAL, PACKAGE SYS.DBMS_STATS_INTERNAL, PACKAGE SYS.DBMS_WORKLOAD_REPLAY_I, PACKAGE SYS.DBMS_XPLAN |
| SYS | PACKAGE | DBMS_SQLTUNE_INTERNAL | TEST_PROCESS_SQLSET | PACKAGE SYS.DBMS_STATS |
| SYS | PACKAGE | DBMS_SQLTUNE_UTIL0 | CHECK_DV_ACCESS | PACKAGE SYS.DBMS_SQLTUNE |
| SYS | PACKAGE | DBMS_SQLTUNE_UTIL1 | GET_SEQ_REMOTE | PACKAGE SYS.DBMS_SQLTUNE_INTERNAL |
| SYS | PACKAGE | DBMS_STATS_INTERNAL | CREATE_TEMP | PACKAGE DBMS_STATS |
| SYS | PACKAGE | DBMS_STATS_INTERNAL | POPULATE_TEMP_INSERT | PACKAGE DBMS_STATS |
| SYS | PACKAGE | DBMS_STATS_INTERNAL_AGG | PACKAGE DBMS_STATS, PACKAGE DBMS_STATS_INTERNAL | |
| SYS | PACKAGE | DBMS_STREAMS_ADM_UTL_INT | SYS.DBMS_STREAMS_ADM_UTL, SYS.DBMS_STREAMS_MT | |
| SYS | PACKAGE | DBMS_STREAMS_RPC | REMOVE_FILE_RC | REMOVE_FILE |
| SYS | PACKAGE | DBMS_STREAMS_TBS_INT | DBMS_FILE_GROUP_UTL_INVOK, DBMS_STREAMS_ADM_UTL, DBMS_STREAMS_MT, DBMS_STREAMS_RPC, DBMS_STREAMS_TABLESPACE_ADM, DBMS_STREAMS_TBS_INT_INVOK | |
| SYS | PACKAGE | DBMS_SUMVDM | DBMS_DIMENSION, DBMS_SUMMARY | |
| SYS | PACKAGE | DBMS_SYNC_REFRESH_INTERNAL | DBMS_SYNC_REFRESH | |
| SYS | PACKAGE | DBMS_TRANSFORM_INTERNAL | PACKAGE SYS.DBMS_TRANSFORM, SYS.DBMS_AQADM, SYS.DBMS_TRANSFORM_EXIMP, SYS.DBMS_TRANSFORM_EXIMP_INTERNAL | |
| SYS | PACKAGE | DBMS_TTS | CONVERTENCRYPTEDDATAFILECOPY | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | DBMS_TTS | GET_AFN_DBID | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | DBMS_TTS | GET_AFN_DBIDXENDIAN | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | DBMS_TTS | PUT_PROTECTED_TSE_KEY | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | DBMS_UMF_PROTECTED | DBMS_ASH_INTERNAL, DBMS_AWR_REPORT_LAYOUT, DBMS_SWRF_REPORT_INTERNAL, DBMS_WORKLOAD_REPOSITORY | |
| SYS | PACKAGE | DBMS_WRR_PROTECTED | DBMS_RAT_MASK_INTERNAL, DBMS_WORKLOAD_CAPTURE, DBMS_WORKLOAD_REPLAY, DBMS_WORKLOAD_REPLAY_I | |
| SYS | PACKAGE | DBMS_XDB_UTIL | PACKAGE 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 | |
| SYS | PACKAGE | DBMS_XDS_INT | PACKAGE SYS.DBMS_XDS | |
| SYS | PACKAGE | KUPC$QUEUE_INT | PREPARE_QUEUE_TABLE | PACKAGE SYS.KUPV$FT_INT |
| SYS | PACKAGE | KUPC$QUEUE_INT | SET_DEBUG | PACKAGE SYS.KUPP$PROC |
| SYS | PACKAGE | KUPC$QUE_INT | PREPARE_QUEUE_TABLE | PACKAGE SYS.KUPC$QUEUE_INT |
| SYS | PACKAGE | KUPC$QUE_INT | SET_DEBUG | PACKAGE SYS.KUPC$QUEUE_INT |
| SYS | PACKAGE | KUPD$DATA | SET_DEBUG | PACKAGE SYS.KUPP$PROC |
| SYS | PACKAGE | KUPD$DATA_INT | GET_OPT_PARAM | PACKAGE KUPD$DATA |
| SYS | PACKAGE | KUPF$FILE | ADD_DEVICE | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | ADD_FILE | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | ALLOCATE_DEVICE | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPF$FILE | CHECK_FATAL_ERROR | PACKAGE SYS.KUPD$DATA |
| SYS | PACKAGE | KUPF$FILE | CLOSE_CONTEXT | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPF$FILE | DELETE_UNUSED_FILE_REFS | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | FILE_REQUEST | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | FILE_REQUEST_NAK | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | FLUSH_LOB | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPF$FILE | GET_BLKBUF_SIZES | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | GET_DEFAULT_FILENAME | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | GET_DUMPFILE_INFO | PACKAGE SYS.DBMS_DATAPUMP |
| SYS | PACKAGE | KUPF$FILE | GET_FILE_LIST | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | GET_FORMATTED_TIME | PACKAGE 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 |
| SYS | PACKAGE | KUPF$FILE | GET_FULL_FILENAME | PACKAGE SYS.DBMS_DATAPUMP, PACKAGE SYS.DBMS_DATAPUMP_INT, PACKAGE SYS.DBMS_DATAPUMP_UTL |
| SYS | PACKAGE | KUPF$FILE | GET_MAX_CSWIDTH | PACKAGE 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 |
| SYS | PACKAGE | KUPF$FILE | INIT | PACKAGE SYS.KUPM$MCP, PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPF$FILE | INIT_TDX_STATS | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPF$FILE | IS_DUMPFILE_SET_CONSISTENT | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | JOB_MODES | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | LOCATE_MASTER | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | MARK_FILES_AS_UNUSABLE | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | MASTER_TABLE_UNLOAD_STARTED | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | OPEN_CONTEXT | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPF$FILE | READ_LOB | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPF$FILE | RELEASE_FILES | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPF$FILE | RESET_EOF | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | SET_DEBUG | PACKAGE SYS.KUPP$PROC |
| SYS | PACKAGE | KUPF$FILE | TERM | PACKAGE SYS.KUPM$MCP, PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPF$FILE | TRACE | PACKAGE 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 |
| SYS | PACKAGE | KUPF$FILE | VERIFY_DUMPFILE_SET | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE | WRITE_LOB | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPF$FILE_INT | CLOSE_CONTEXT | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | CREATE_DUMP_FILE | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | CREATE_KEY_INFO | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE_INT | DELETE_DUMP_FILE | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | ENCODE_PWD | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE_INT | EXAMINE_DUMP_FILE | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | FLUSH_LOB | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | GET_BLKBUF_SIZES | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | GET_DEBUG_EVENT | PACKAGE SYS.KUPF$FILE, PACKAGE SYS.UTL_XML |
| SYS | PACKAGE | KUPF$FILE_INT | GET_DEFAULT_CREDENTIAL | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE_INT | GET_DEFAULT_FILENAME | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | GET_ENCODED_PWD | PACKAGE SYS.KUPF$FILE, PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE_INT | GET_FORMATTED_TIME | PACKAGE 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 |
| SYS | PACKAGE | KUPF$FILE_INT | GET_FULL_FILENAME | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | GET_MAX_CSWIDTH | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | GTOP | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPF$FILE_INT | INIT | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | IS_DUMPFILE_A_RESTFILE | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE_INT | OPEN_CONTEXT | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | PARSE_FILENAME | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | READ_LOB | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | RELEASE_FILES | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | SET_DEBUG | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | SET_TRANS_PARAMS | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | TERM | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPF$FILE_INT | VERIFY_KEY_INFO | PACKAGE SYS.KUPF$FILE, PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPF$FILE_INT | WRITE_LOB | PACKAGE SYS.KUPF$FILE |
| SYS | PACKAGE | KUPM$MCP | CLOSE_JOB | PACKAGE SYS.DBMS_DATAPUMP |
| SYS | PACKAGE | KUPM$MCP | DISPATCH | PACKAGE SYS.KUPC$QUEUE |
| SYS | PACKAGE | KUPM$MCP | SET_DEBUG | PACKAGE SYS.KUPP$PROC |
| SYS | PACKAGE | KUPP$PROC | CREATE_MASTER_PROCESS | PACKAGE SYS.KUPV$FT |
| SYS | PACKAGE | KUPP$PROC | CREATE_WORKER_PROCESSES | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPU$UTILITIES | GET_REMOTE_DBLINK_USER | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPU$UTILITIES | REPLACE_XML_VALUES | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPU$UTILITIES_INT | CHECK_TBS_FOR_TDECOL_TABS | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPU$UTILITIES_INT | CREATE_DIRECTORY | PACKAGE SYS.DBMS_DATAPUMP_UTL |
| SYS | PACKAGE | KUPU$UTILITIES_INT | DEBUG | PACKAGE SYS.KUPU$UTILITIES |
| SYS | PACKAGE | KUPU$UTILITIES_INT | DIRECTORY_SCAN | PACKAGE SYS.DBMS_PLUGTS, PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPU$UTILITIES_INT | GET_DP_UPDATE_LOCK | PACKAGE SYS.DBMS_METADATA, PACKAGE SYS.DBMS_METADATA_DIFF, PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPU$UTILITIES_INT | GET_PARAMETER_VALUE | PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPU$UTILITIES_INT | GET_REMOTE_DBLINK_USER | PACKAGE SYS.KUPU$UTILITIES |
| SYS | PACKAGE | KUPU$UTILITIES_INT | INTALGCONV | PACKAGE SYS.DBMS_METADATA_UTIL, PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPU$UTILITIES_INT | RELEASE_DP_UPDATE_LOCK | PACKAGE SYS.DBMS_METADATA, PACKAGE SYS.DBMS_METADATA_DIFF, PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPU$UTILITIES_INT | SET_DEBUG | PACKAGE SYS.KUPP$PROC |
| SYS | PACKAGE | KUPV$FT | ATTACH_JOB | PACKAGE SYS.DBMS_DATAPUMP, PACKAGE SYS.KUPM$MCP, PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPV$FT | OPEN_JOB | PACKAGE SYS.DBMS_DATAPUMP |
| SYS | PACKAGE | KUPV$FT_INT | ACTIVE_CLIENT_COUNT | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPV$FT_INT | BUILD_MTABLE_INDEXES | PACKAGE SYS.KUPM$MCP |
| SYS | PACKAGE | KUPV$FT_INT | CREATE_NEW_JOB | PACKAGE SYS.KUPV$FT |
| SYS | PACKAGE | KUPV$FT_INT | DEBUG_ENABLED | PACKAGE SYS.KUPV$FT |
| SYS | PACKAGE | KUPV$FT_INT | GET_DEBUG_INFO | PACKAGE SYS.KUPV$FT |
| SYS | PACKAGE | KUPV$FT_INT | ON_BEHALF | PACKAGE SYS.KUPV$FT |
| SYS | PACKAGE | KUPV$FT_INT | SET_DEBUG | PACKAGE SYS.KUPP$PROC |
| SYS | PACKAGE | KUPV$FT_INT | SET_EVENT | PACKAGE SYS.KUPC$QUE_INT, PACKAGE SYS.KUPD$DATA, PACKAGE SYS.KUPP$PROC, PACKAGE SYS.KUPW$WORKER |
| SYS | PACKAGE | KUPW$WORKER | SET_DEBUG | PACKAGE SYS.KUPP$PROC |
| SYS | PACKAGE | OUTLN_PKG_INTERNAL | PACKAGE SYS.OUTLN_PKG | |
| SYS | PACKAGE | PRVT_ACCESS_ADVISOR | SETUP_USER | PACKAGE PRVT_ADVISOR |
| SYS | PACKAGE | UTL_XML | PARSEEXPR | PACKAGE SYS.DBMS_METADATA |
| SYS | PACKAGE | UTL_XML | PARSEQUERY | PACKAGE SYS.DBMS_METADATA |
| SYS | PACKAGE | WWV_DBMS_SQL_APEX_050100 | APEX_050100.WWV_FLOW_DYNAMIC_EXEC, APEX_050100.WWV_FLOW_SESSION_RAS, APEX_050100.WWV_FLOW_UPGRADE | |
| SYS | PACKAGE | XS_DATA_SECURITY_UTIL_INT | PACKAGE XS_DATA_SECURITY_UTIL | |
| SYS | PROCEDURE | EXECASUSER | PACKAGE 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 | |
| WMSYS | PACKAGE | LTADM | PACKAGE 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 | |
| WMSYS | PACKAGE | LTAQ | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM | |
| WMSYS | PACKAGE | LTDDL | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.WM_DDL_UTIL | |
| WMSYS | PACKAGE | LTDTRG | PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.UD_TRIGS, PACKAGE WMSYS.WM_DDL_UTIL | |
| WMSYS | PACKAGE | LTPRIV | PACKAGE WMSYS.LT | |
| WMSYS | PACKAGE | LTRIC | GETVARIABLE_C | PACKAGE WMSYS.OWM_DYNSQL_ACCESS |
| WMSYS | PACKAGE | LTRIC | SETVARIABLE | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTRIC | PACKAGE 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 | |
| WMSYS | PACKAGE | LTUTIL | ADDUSERDEFINEDHINT | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | ADDWCP | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | ALLOCATE_UNIQUE | PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | ALLOWROWLEVELLOCKING | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | CHECKADDTOPOGEOLAYERERRORS | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | CHECKDELTOPOGEOLAYERERRORS | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | CHECKDOMAININDEXPRIVS | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | CLEANUPBDDL | PACKAGE WMSYS.OWM_DDL_PKG |
| WMSYS | PACKAGE | LTUTIL | CLEANUPCDDL | PACKAGE WMSYS.OWM_DDL_PKG |
| WMSYS | PACKAGE | LTUTIL | CLEANUPDV | PACKAGE WMSYS.LTDDL |
| WMSYS | PACKAGE | LTUTIL | CLEANUPEV | PACKAGE WMSYS.LTDDL |
| WMSYS | PACKAGE | LTUTIL | CLEANUPMETADATA | PACKAGE WMSYS.LTDDL |
| WMSYS | PACKAGE | LTUTIL | CLEANUPMETADATABYUSER | PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_DYNSQL_ACCESS |
| WMSYS | PACKAGE | LTUTIL | CLEANUPSTALEMETADATA | PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS |
| WMSYS | PACKAGE | LTUTIL | CREATEINLISTFROMQUERY | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | CREATEPKWHERECLAUSE | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC |
| WMSYS | PACKAGE | LTUTIL | DELETEFULLROLLBACKMARKER | PACKAGE WMSYS.LT_CTX_PKG |
| WMSYS | PACKAGE | LTUTIL | DELETEUNDOCODE | PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DDL_PKG |
| WMSYS | PACKAGE | LTUTIL | DELETEUNDOCODECHECKPOINTS | PACKAGE WMSYS.LT_CTX_PKG |
| WMSYS | PACKAGE | LTUTIL | DELETEUNDOCODERANGE | PACKAGE WMSYS.LTDDL |
| WMSYS | PACKAGE | LTUTIL | DISALLOWIFWITHVT | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | EXECEVUNDO | PACKAGE WMSYS.LTDDL |
| WMSYS | PACKAGE | LTUTIL | EXECLOG | PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | EXECUTESQLLOG | PACKAGE WMSYS.LT, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_MIG_PKG |
| WMSYS | PACKAGE | LTUTIL | EXISTSBIR | PACKAGE WMSYS.LTRIC |
| WMSYS | PACKAGE | LTUTIL | EXISTSBUR | PACKAGE WMSYS.LTRIC |
| WMSYS | PACKAGE | LTUTIL | EXISTSCONSTRAINT | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | EXISTSFULLROLLBACKMARKER | PACKAGE WMSYS.LTDDL |
| WMSYS | PACKAGE | LTUTIL | EXISTSTOPOLOGY | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | FIXTOPOLOGYIMPORT | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | FIXVTAB_COMPRESS | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | FIXVTAB_REFRESH | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | FIXVTAB_ROLLBACK | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | GENFIXCRNONSEQNFRESHINS | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | GENWMCOLSUPDATESTMNT | PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | GETBASETABLENAME | PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | GETBATCHWHERECLAUSES | PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_DYNSQL_ACCESS |
| WMSYS | PACKAGE | LTUTIL | GETCOLINFO | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_IEXP_PKG |
| WMSYS | PACKAGE | LTUTIL | GETCOLLIST | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | GETCOLSTR | PACKAGE 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 |
| WMSYS | PACKAGE | LTUTIL | GETCOLUMNPLUSEXPRESSION | PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | GETCRSTATUS | PACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_BULK_LOAD_PKG |
| WMSYS | PACKAGE | LTUTIL | GETCURRENTLOCKINGMODE | PACKAGE WMSYS.LT_CTX_PKG |
| WMSYS | PACKAGE | LTUTIL | GETCURVER | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_IEXP_PKG |
| WMSYS | PACKAGE | LTUTIL | GETDISTINCTOBJECT | PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | GETDISVER | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | GETHISTOPTION | PACKAGE 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 |
| WMSYS | PACKAGE | LTUTIL | GETINDEXTABLE | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTDTRG |
| WMSYS | PACKAGE | LTUTIL | GETINDEXTABLESPACE | PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | GETNESTEDCOLUMNVIEW | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | GETNESTEDTABLECOLSTR | PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | GETNESTEDTABLEMETADATACOLUMNS | PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | GETNESTEDTABLETYPE | PACKAGE WMSYS.OWM_DDL_PKG |
| WMSYS | PACKAGE | LTUTIL | GETNEXTVERSION | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | GETNOTNULLCONSTRAINT | PACKAGE WMSYS.OWM_DDL_PKG |
| WMSYS | PACKAGE | LTUTIL | GETNTPKEYCOLS | PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_MP_PKG |
| WMSYS | PACKAGE | LTUTIL | GETPKEYINFO | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | GETPKEYINFO_VT | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | GETPKINDEXINFO | PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | GETRLSWHERECLAUSE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | GETSEQUENCEOPTIONS | PACKAGE WMSYS.OWM_DDL_PKG |
| WMSYS | PACKAGE | LTUTIL | GETSID | PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LT_CTX_PKG |
| WMSYS | PACKAGE | LTUTIL | GETSNO | PACKAGE WMSYS.LT_CTX_PKG |
| WMSYS | PACKAGE | LTUTIL | GETSPACEUSAGE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | GETTABLETABLESPACE | PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_DDL_PKG, WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | GETTOPOFEATURETABINFO | PACKAGE WMSYS.LTDTRG |
| WMSYS | PACKAGE | LTUTIL | GETTOPOINFO | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | GETTRIGGERS | PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG |
| WMSYS | PACKAGE | LTUTIL | GETUDHINT | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | GETUNDOCODECLOB | PACKAGE WMSYS.OWM_BULK_LOAD_PKG |
| WMSYS | PACKAGE | LTUTIL | GETVALIDTIMEOPTION | PACKAGE 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 |
| WMSYS | PACKAGE | LTUTIL | GETVARIABLE_R | PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | GETVERINDEXNAME | PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.OWM_MP_PKG |
| WMSYS | PACKAGE | LTUTIL | GETVTID | PACKAGE 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 |
| WMSYS | PACKAGE | LTUTIL | GETWHERECLAUSESTR | PACKAGE 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 |
| WMSYS | PACKAGE | LTUTIL | GETWORKSPACELOCKID | PACKAGE 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 |
| WMSYS | PACKAGE | LTUTIL | GETWORKSPACELOCKMODE | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | GET_EXPANDED_NEXTVERS_NP | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | GRANTOLSPRIVS | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | HASCRCHILD | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTRIC |
| WMSYS | PACKAGE | LTUTIL | HASDEFERREDCHILD | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | HASFEATURETABLE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | HASNESTEDTABLECOLUMN | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | HASOLSPOLICY | PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | HASRICCASCADINGCONSTRAINT | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | HASRICSETNULLCONSTRAINT | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | HASVIRTUALCOLUMN | PACKAGE WMSYS.LTDTRG |
| WMSYS | PACKAGE | LTUTIL | HASWOOVERWRITEOPTION | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTRIC |
| WMSYS | PACKAGE | LTUTIL | HISTWITHDATETYPE | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG |
| WMSYS | PACKAGE | LTUTIL | HISTWITHDATETYPEEV | PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | INSERTFULLROLLBACKMARKER | PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LT_CTX_PKG |
| WMSYS | PACKAGE | LTUTIL | INVERSIONEDSTATE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | ISIMPLICITSP | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | ISLEAFSTATE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | ISMODIFIED | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | ISMODIFIEDINSUBTREE | PACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_DYNSQL_ACCESS |
| WMSYS | PACKAGE | LTUTIL | ISOBJECTTABLE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | ISSPATIALINSTALLED | PACKAGE 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 |
| WMSYS | PACKAGE | LTUTIL | ISSPLITINSUBTREE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | ISTOPOFEATURETABLE | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG |
| WMSYS | PACKAGE | LTUTIL | ISTOPOLOGYINDEXTABLE | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LT_EXPORT_PKG |
| WMSYS | PACKAGE | LTUTIL | ISTOPOLOGYRELATIONTABLE | PACKAGE WMSYS.LTDTRG |
| WMSYS | PACKAGE | LTUTIL | ISVERSIONEDTABLE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | ISVERSIONENABLEDTOPOLOGY | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | ISWORKSPACEOWNER | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | MOVEWMMETADATA | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | NEEDTOEXECUTETRIGGERS | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | NUMTRIGGERSTOEXECUTE | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | PARSESTRINGLIST | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | POPULATEROWIDRANGES | PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | PREFIXSTR | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | QB_BLOCK_REPLACE | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | REMOVEUSERDEFINEDHINT | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | RENAMESAVEPOINT | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | RENAMEWORKSPACE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | REQUIRESTRIGGERSONTOPVIEW | PACKAGE WMSYS.LTDTRG |
| WMSYS | PACKAGE | LTUTIL | RESETALLSEQUENCES | PACKAGE WMSYS.LT_EXPORT_PKG |
| WMSYS | PACKAGE | LTUTIL | RESOLVESYNONYM | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC |
| WMSYS | PACKAGE | LTUTIL | RESTARTSEQUENCE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | SEPARATECLOBINTO2PARTS | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | SETVARIABLE | PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LTUTIL | TOPOTABLECHECK | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | TO_CLOB_ | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LTUTIL | UPDATESDOTOPOMETADATADV | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | UPDATESDOTOPOMETADATAEV | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LTUTIL | WM$GETDBCOMPATIBLESTR | PACKAGE WMSYS.OWM_IEXP_PKG |
| WMSYS | PACKAGE | LTUTIL | WRITETOLOG | PACKAGE 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 |
| WMSYS | PACKAGE | LT_CTX_PKG | ALLOWDDLOPERATION | PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS |
| WMSYS | PACKAGE | LT_CTX_PKG | CHVLTL | PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LT_CTX_PKG | GETLTTABLENAME | WMSYS.LTDTRG |
| WMSYS | PACKAGE | LT_CTX_PKG | GETMULTIWORKSPACES | WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | GETPURGEOPTION | PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.WM_DDL_UTIL |
| WMSYS | PACKAGE | LT_CTX_PKG | GETSESSIONATTRIBUTES | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LT_EXPORT_PKG |
| WMSYS | PACKAGE | LT_CTX_PKG | GETVARIABLE_B | PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS |
| WMSYS | PACKAGE | LT_CTX_PKG | GETVARIABLE_N | PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.OWM_DYNSQL_ACCESS |
| WMSYS | PACKAGE | LT_CTX_PKG | GETVARIABLE_V | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTAQ, PACKAGE WMSYS.LTUTIL |
| WMSYS | PACKAGE | LT_CTX_PKG | GETVTTABLENAME | WMSYS.LTDTRG |
| WMSYS | PACKAGE | LT_CTX_PKG | SETACTIVETIMEFORDML | WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETCALLSTACKASINVALID | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG |
| WMSYS | PACKAGE | LT_CTX_PKG | SETCALLSTACKASVALID | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG |
| WMSYS | PACKAGE | LT_CTX_PKG | SETCOMMITVARS | WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETCOMPRESSWORKSPACE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETCONFLICTSTATE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETCOPYVARS | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETDIFFVERS | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETFLIPVERSIONONREFRESH | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETFREEZESTATUS | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LT_CTX_PKG | SETIMPORTVARS | PACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_DYNSQL_ACCESS |
| WMSYS | PACKAGE | LT_CTX_PKG | SETINSTANT | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_IEXP_PKG |
| WMSYS | PACKAGE | LT_CTX_PKG | SETLOCKMODE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETMPROOT | PACKAGE WMSYS.OWM_MP_PKG |
| WMSYS | PACKAGE | LT_CTX_PKG | SETMPWORKSPACE | PACKAGE WMSYS.OWM_MP_PKG |
| WMSYS | PACKAGE | LT_CTX_PKG | SETMULTIWORKSPACES | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETNEWMPVARS | PACKAGE WMSYS.OWM_MP_PKG |
| WMSYS | PACKAGE | LT_CTX_PKG | SETNEWROOTANCVERSION | PACKAGE WMSYS.OWM_MP_PKG |
| WMSYS | PACKAGE | LT_CTX_PKG | SETOPCONTEXT | PACKAGE WMSYS.LTUTIL |
| WMSYS | PACKAGE | LT_CTX_PKG | SETPOSTVARS | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETROWLOCKSTATUS | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETSAVEPOINT | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LT_CTX_PKG | SETSTATEATTRIBUTES | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETTABMRGWOREMOVEEVENT | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETTABMRGWREMOVEEVENT | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETTABREFRESHEVENT | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETTRIGGEREVENT | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETTSINSTANT | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LT_CTX_PKG | SETUSER | PACKAGE WMSYS.LTPRIV |
| WMSYS | PACKAGE | LT_CTX_PKG | SETVALIDTIME | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETVALIDTIMEFILTEROFF | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETVALIDTIMEFILTERON | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETVARIABLE | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.OWM_IEXP_PKG |
| WMSYS | PACKAGE | LT_CTX_PKG | SETVERAFTINSTANT | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LT_CTX_PKG | SETVERBEFINSTANT | PACKAGE WMSYS.LTADM |
| WMSYS | PACKAGE | LT_CTX_PKG | SETVERSION | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_IEXP_PKG |
| WMSYS | PACKAGE | LT_CTX_PKG | SETVERSIONANDSTATE | PACKAGE WMSYS.OWM_IEXP_PKG |
| WMSYS | PACKAGE | LT_CTX_PKG | SETWRITERSTATE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETWSPCMRGWOREMOVEEVENT | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | SETWSPCMRGWREMOVEEVENT | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | TO_TIMESTAMP_TZ_ | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | UNSETCOMMITVARS | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | UNSETCOPYVARS | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_CTX_PKG | UNSETIMPORTVARS | PACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_DYNSQL_ACCESS |
| WMSYS | PACKAGE | LT_CTX_PKG | UNSETPOSTVARS | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | LT_EXPORT_PKG | EXPORT_SCHEMAS | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | OWM_ASSERT_PKG | PACKAGE 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 | |
| WMSYS | PACKAGE | OWM_BULK_LOAD_PKG | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_DYNSQL_ACCESS | |
| WMSYS | PACKAGE | OWM_CPKG_PKG | PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG | |
| WMSYS | PACKAGE | OWM_DDL_PKG | PACKAGE 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 | |
| WMSYS | PACKAGE | OWM_DML_PKG | 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$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 | |
| WMSYS | PACKAGE | OWM_IEXP_PKG | PACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_DYNSQL_ACCESS | |
| WMSYS | PACKAGE | OWM_MIG_PKG | RECOVERMIGRATINGTABLE | PACKAGE WMSYS.LT |
| WMSYS | PACKAGE | OWM_MP_PKG | PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTPRIV, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS | |
| WMSYS | PACKAGE | OWM_VSCRIPT_PKG | STARTQUEUE | PACKAGE WMSYS.LT_EXPORT_PKG |
| WMSYS | PACKAGE | OWM_VSCRIPT_PKG | STOPQUEUE | PACKAGE WMSYS.LT_EXPORT_PKG |
| WMSYS | PACKAGE | OWM_VSCRIPT_PKG | WM$CONVERTVERSIONSTR | PACKAGE WMSYS.LTUTIL |
| WMSYS | PACKAGE | OWM_VSCRIPT_PKG | WM$GETDBPARAMETER | PACKAGE WMSYS.LT_CTX_PKG |
| WMSYS | PACKAGE | UD_TRIGS | PACKAGE 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 | |
| WMSYS | PACKAGE | WM_DDL_UTIL | PACKAGE 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 | |
| XDB | PACKAGE | DBMS_CLOBUTIL | PACKAGE XDB.DBMS_XMLDOM, PACKAGE XDB.DBMS_XMLPARSER, PACKAGE XDB.DBMS_XSLPROCESSOR | |
| XDB | PACKAGE | DBMS_JSON_INT | PACKAGE XDB.DBMS_JSON | |
| XDB | PACKAGE | DBMS_SODA_DML | PACKAGE 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)