{"id":8230,"date":"2018-04-30T18:10:41","date_gmt":"2018-04-30T16:10:41","guid":{"rendered":"https:\/\/www.salvis.com\/blog\/?p=8230"},"modified":"2023-11-08T01:25:35","modified_gmt":"2023-11-08T00:25:35","slug":"accessible-pl-sql-programs-in-oracle-database-18c","status":"publish","type":"post","link":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/","title":{"rendered":"Accessible PL\/SQL Programs in Oracle Database 18c"},"content":{"rendered":"\n

I’ve recently installed plscope-utils<\/a> in an Oracle Database 18c instance. A package body using the SYS.UTL_XML.ParseQuery<\/code> 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<\/code> parameter. But then I’ve got the next error message.<\/p>\n\n\n\n

\n

PLS-00904: insufficient privilege to access object PARSEQUERY.<\/p>\n<\/blockquote>\n\n\n\n

The excerpt of the SYS.UTL_XML<\/code> package specification reveals the cause of this error.<\/p>\n\n\n\n

Excerpt from SYS.UTL_XML<\/span><\/path><\/path><\/svg><\/span>
-- PARSEQUERY: Parse a SQL query and return in a CLOB as XML<\/span><\/span>\n-- PARAMS:<\/span><\/span>\n--      currUid         - UID of current user<\/span><\/span>\n--      schema          - schem to use for parse<\/span><\/span>\n--      sqltext         - the text of the query<\/span><\/span>\n--      lobloc          - a LOB locator to receive the parsed value<\/span><\/span>\n<\/span>\nPROCEDURE<\/span> <\/span>parseQuery<\/span>   (currUid <\/span>IN<\/span> <\/span>NUMBER<\/span>,<\/span><\/span>\n                        schema  <\/span>IN<\/span> <\/span>VARCHAR2<\/span>,<\/span><\/span>\n                        sqltext <\/span>IN<\/span> <\/span>CLOB<\/span>,<\/span><\/span>\n                        lobloc  <\/span>IN<\/span> <\/span>OUT<\/span> <\/span>NOCOPY<\/span> <\/span>CLOB<\/span><\/span>\n                       )<\/span><\/span>\n  ACCESSIBLE BY (<\/span>PACKAGE<\/span> <\/span>SYS.DBMS_METADATA);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
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.\u00a0The accessible-by-lists help plan upgrade projects, validate role concepts\/implementations or support development tasks such as generating utPLSQL<\/a> unit test stubs for a PL\/SQL package (ignoring inaccessible subprograms).<\/p>\n\n\n\n
However, currently, it is not that easy to get information about PL\/SQL units and subprograms which are restricted by an accessible_by_clause.\u00a0 There is no Oracle data dictionary view or API exposing this data. The Oracle enhancement request\u00a027871459 addresses this issue. If you have an Oracle support account, please open an SR and add your CSI to this enhancement request. This should be a well-known task for an Oracle support engineer.<\/p>\n\n\n\n
I’ve created a script named procedure_accessors.sql<\/a><\/code>\u00a0to query accessors for all PL\/SQL units and their 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<\/code> 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.<\/p>\n\n\n\n
Please note, that this query requires an Oracle Database 12c Release 2 (12.2) instance or newer.<\/p>\n\n\n\n
Query Accessors (procedure_accessors.sql)<\/span><\/path><\/path><\/svg><\/span>
WITH<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- remove multi-line comments from source<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>FUNCTION<\/span> remove_ml_comments (in_source <\/span>IN<\/span> CLOB) <\/span>RETURN<\/span> CLOB <\/span>IS<\/span><\/span>\n   <\/span>BEGIN<\/span> <\/span><\/span>\n      <\/span>RETURN<\/span> regexp_replace(in_source, <\/span>'\/\\*.*?\\*\/'<\/span>, <\/span>NULL<\/span>, <\/span>1<\/span>, <\/span>0<\/span>, <\/span>'n'<\/span>);<\/span><\/span>\n   <\/span>END<\/span> remove_ml_comments;<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- remove single-line comments from source<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>FUNCTION<\/span> remove_sl_comments (in_source <\/span>IN<\/span> CLOB) <\/span>RETURN<\/span> CLOB <\/span>IS<\/span><\/span>\n   <\/span>BEGIN<\/span> <\/span><\/span>\n      <\/span>RETURN<\/span> regexp_replace(in_source, <\/span>'--.*'<\/span>);<\/span><\/span>\n   <\/span>END<\/span> remove_sl_comments;<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- remove simple string literals from source<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>FUNCTION<\/span> remove_simple_string_literals (in_source <\/span>IN<\/span> CLOB) <\/span>RETURN<\/span> CLOB <\/span>IS<\/span><\/span>\n   <\/span>BEGIN<\/span> <\/span><\/span>\n      <\/span>RETURN<\/span> regexp_replace(in_source, q<\/span>'['<\/span>.*?<\/span>']'<\/span>, <\/span>NULL<\/span>, <\/span>1<\/span>, <\/span>0<\/span>, <\/span>'n'<\/span>);<\/span><\/span>\n   <\/span>END<\/span> remove_simple_string_literals;<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- remove quoted string literals from source<\/span><\/span>\n   <\/span>-- supporting the following quote_delimiter pairs only: (), {}, [], <>, $, ##, @@, \u00a3\u00a3, "", \/\/, ||, !!, ++, ~~<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>FUNCTION<\/span> remove_quoted_string_literals (<\/span><\/span>\n      in_source <\/span>IN<\/span> CLOB<\/span><\/span>\n   ) <\/span>RETURN<\/span> CLOB <\/span>IS<\/span><\/span>\n      co_pattern CONSTANT <\/span>VARCHAR2<\/span>(<\/span>200<\/span>) :=<\/span><\/span>\n         q<\/span>'[n?q'<\/span>((\\(.*?\\))|(\\{.*?\\})|(\\[.*?\\])|(<.*?>)|(\\$.*?\\$)|(#.*?#)|(@.*?@)|(\u00a3.*?\u00a3)|(<\/span>".*?"<\/span>)|(\/.*?\/)|(\\|.*?\\|)|(!.*?!)|(\\+.*?\\+)|(~.*?~))<\/span>']'<\/span>;<\/span><\/span>\n   <\/span>BEGIN<\/span><\/span>\n      <\/span>RETURN<\/span> regexp_replace(in_source, co_pattern, <\/span>NULL<\/span>, <\/span>1<\/span>, <\/span>0<\/span>, <\/span>'in'<\/span>);<\/span><\/span>\n   <\/span>END<\/span> remove_quoted_string_literals;<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- remove all string literals and comments from source<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>FUNCTION<\/span> remove_all (in_source <\/span>IN<\/span> CLOB) <\/span>RETURN<\/span> CLOB <\/span>IS<\/span><\/span>\n      l_clob CLOB := in_source;<\/span><\/span>\n   <\/span>BEGIN<\/span> <\/span><\/span>\n      l_clob := remove_sl_comments(l_clob);<\/span><\/span>\n      l_clob := remove_quoted_string_literals(l_clob);<\/span><\/span>\n      l_clob := remove_simple_string_literals(l_clob);<\/span><\/span>\n      l_clob := remove_ml_comments(l_clob);<\/span><\/span>\n      <\/span>return<\/span> l_clob;<\/span><\/span>\n   <\/span>END<\/span> remove_all;<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- get subprogram associated with the accessible_by_clause in JSON format, e.g.<\/span><\/span>\n   <\/span>--    {<\/span><\/span>\n   <\/span>--       "id": 5,<\/span><\/span>\n   <\/span>--       "type": "PROCEDURE",<\/span><\/span>\n   <\/span>--       "name": "parseQuery",<\/span><\/span>\n   <\/span>--    }<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- return NULL if accessible_by_clause is for the PL\/SQL unit<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>FUNCTION<\/span> get_subprogram(<\/span><\/span>\n      in_object_type <\/span>VARCHAR2<\/span>,<\/span><\/span>\n      in_source      CLOB,<\/span><\/span>\n      in_pos         <\/span>INTEGER<\/span><\/span>\n   ) <\/span>RETURN<\/span> <\/span>VARCHAR2<\/span> <\/span>IS<\/span><\/span>\n      l_subprogram json_object_t;<\/span><\/span>\n      co_pattern   CONSTANT <\/span>VARCHAR2<\/span>(<\/span>100<\/span> <\/span>CHAR<\/span>) := <\/span>'(function|procedure)(\\s+)("?[a-zA-Z0-9_#$]+"?)'<\/span>;<\/span><\/span>\n      l_source     CLOB;<\/span><\/span>\n      l_count      <\/span>INTEGER<\/span>;<\/span><\/span>\n      l_match      <\/span>VARCHAR2<\/span>(<\/span>4000<\/span> <\/span>CHAR<\/span>);<\/span><\/span>\n   <\/span>BEGIN<\/span><\/span>\n      l_subprogram := json_object_t();<\/span><\/span>\n      <\/span>IF<\/span> in_object_type <\/span>NOT<\/span> <\/span>IN<\/span> (<\/span>'FUNCTION'<\/span>, <\/span>'PROCEDURE'<\/span>) <\/span>THEN<\/span><\/span>\n         l_source := regexp_replace(substr(in_source, <\/span>1<\/span>, in_pos - <\/span>1<\/span>), <\/span>'accessible\\s+by\\s*\\(.*?\\)'<\/span>, <\/span>NULL<\/span>, <\/span>1<\/span>, <\/span>0<\/span>, <\/span>'in'<\/span>);<\/span><\/span>\n         l_count := regexp_count(l_source, co_pattern, <\/span>1<\/span>, <\/span>'in'<\/span>);<\/span><\/span>\n         <\/span>IF<\/span> l_count > <\/span>0<\/span> <\/span>THEN<\/span><\/span>\n            l_match := regexp_substr(l_source, co_pattern, <\/span>1<\/span>, l_count, <\/span>'in'<\/span>);<\/span><\/span>\n            l_subprogram.put(<\/span>'id'<\/span>, l_count);<\/span><\/span>\n            l_subprogram.put(<\/span>'type'<\/span>, regexp_substr(l_match, co_pattern, <\/span>1<\/span>, <\/span>1<\/span>, <\/span>'in'<\/span>, <\/span>1<\/span>));<\/span><\/span>\n            l_subprogram.put(<\/span>'name'<\/span>, regexp_substr(l_match, co_pattern, <\/span>1<\/span>, <\/span>1<\/span>, <\/span>'in'<\/span>, <\/span>3<\/span>));<\/span><\/span>\n         <\/span>END<\/span> <\/span>IF<\/span>;<\/span><\/span>\n      <\/span>END<\/span> <\/span>IF<\/span>;<\/span><\/span>\n      <\/span>RETURN<\/span> l_subprogram.to_string();<\/span><\/span>\n   <\/span>END<\/span> get_subprogram;<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- get the list of subprograms and its accessors as JSON array, e.g.<\/span><\/span>\n   <\/span>--    [<\/span><\/span>\n   <\/span>--        {<\/span><\/span>\n   <\/span>--            "id": 5,<\/span><\/span>\n   <\/span>--            "type": "PROCEDURE",<\/span><\/span>\n   <\/span>--            "name": "parseQuery",<\/span><\/span>\n   <\/span>--            "accessors": [<\/span><\/span>\n   <\/span>--                {<\/span><\/span>\n   <\/span>--                    "unit_kind": "PACKAGE",<\/span><\/span>\n   <\/span>--                    "schema": "SYS",<\/span><\/span>\n   <\/span>--                    "unit_name": "DBMS_METADATA"<\/span><\/span>\n   <\/span>--                }<\/span><\/span>\n   <\/span>--            ]<\/span><\/span>\n   <\/span>--        }<\/span><\/span>\n   <\/span>--    ]<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>FUNCTION<\/span> get_accessors(<\/span><\/span>\n      in_object_type          <\/span>VARCHAR2<\/span>,<\/span><\/span>\n      in_source               CLOB,<\/span><\/span>\n      in_accessible_by_count  <\/span>INTEGER<\/span><\/span>\n   ) <\/span>RETURN<\/span> CLOB <\/span>IS<\/span><\/span>\n      co_full_clause_pattern CONSTANT <\/span>VARCHAR2<\/span>(<\/span>100<\/span> <\/span>CHAR<\/span>) := <\/span>'accessible\\s+by\\s*\\(.*?\\)'<\/span>;<\/span><\/span>\n      co_accessor_pattern    CONSTANT <\/span>VARCHAR2<\/span>(<\/span>200<\/span> <\/span>CHAR<\/span>) := <\/span><\/span>\n         <\/span>'(\\(|,)(\\s*)(function|procedure|package|trigger|type)?(\\s*)("?[a-zA-Z0-9_#$]+"?\\s*\\.)?("?[a-zA-Z0-9_#$]+"?)'<\/span>;<\/span><\/span>\n      l_subprograms          json_array_t;<\/span><\/span>\n      l_subprogram           json_object_t;<\/span><\/span>\n      l_full_clause          <\/span>VARCHAR2<\/span>(<\/span>4000<\/span> <\/span>CHAR<\/span>);<\/span><\/span>\n      l_accessors            json_array_t;<\/span><\/span>\n      l_accessor             json_object_t;<\/span><\/span>\n      l_pos                  <\/span>INTEGER<\/span>;<\/span><\/span>\n      l_accessor_count       <\/span>INTEGER<\/span>;<\/span><\/span>\n   <\/span>BEGIN<\/span><\/span>\n      l_subprograms := json_array_t();<\/span><\/span>\n      <<accessible_by_clauses>><\/span><\/span>\n      <\/span>FOR<\/span> i <\/span>in<\/span> <\/span>1<\/span> .. in_accessible_by_count <\/span>LOOP<\/span><\/span>\n         l_pos := regexp_instr(in_source, co_full_clause_pattern, <\/span>1<\/span>, i, <\/span>0<\/span>, <\/span>'in'<\/span>);<\/span><\/span>\n         l_subprogram := json_object_t.parse(get_subprogram(in_object_type, in_source, l_pos));<\/span><\/span>\n         l_full_clause := regexp_substr(in_source, co_full_clause_pattern, <\/span>1<\/span>, i, <\/span>'in'<\/span>);<\/span><\/span>\n         l_accessor_count := regexp_count(l_full_clause, co_accessor_pattern, <\/span>1<\/span>, <\/span>'in'<\/span>);<\/span><\/span>\n         l_accessors := json_array_t();<\/span><\/span>\n         <<accessors>><\/span><\/span>\n         <\/span>FOR<\/span> j <\/span>in<\/span> <\/span>1<\/span> .. l_accessor_count <\/span>LOOP<\/span><\/span>\n            l_accessor := json_object_t();<\/span><\/span>\n            l_accessor.put(<\/span>'unit_kind'<\/span>, regexp_substr(l_full_clause, co_accessor_pattern, <\/span>1<\/span>, j, <\/span>'in'<\/span>, <\/span>3<\/span>));<\/span><\/span>\n            l_accessor.put(<\/span>'schema'<\/span>, <\/span>replace<\/span>(regexp_substr(l_full_clause, co_accessor_pattern, <\/span>1<\/span>, j, <\/span>'in'<\/span>, <\/span>5<\/span>),<\/span>'.'<\/span>));<\/span><\/span>\n            l_accessor.put(<\/span>'unit_name'<\/span>, regexp_substr(l_full_clause, co_accessor_pattern, <\/span>1<\/span>, j, <\/span>'in'<\/span>, <\/span>6<\/span>));<\/span><\/span>\n            l_accessors.append(l_accessor);<\/span><\/span>\n         <\/span>END<\/span> <\/span>LOOP<\/span> accessors;<\/span><\/span>\n         l_subprogram.put(<\/span>'accessors'<\/span>, l_accessors);<\/span><\/span>\n         l_subprograms.append(l_subprogram);<\/span><\/span>\n      <\/span>END<\/span> <\/span>LOOP<\/span> accessible_by_clauses;<\/span><\/span>\n      <\/span>return<\/span> l_subprograms.to_clob();<\/span><\/span>\n   <\/span>END<\/span> get_accessors;<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- ensure identifier matches case sensitive name in Orace data dictionary <\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>FUNCTION<\/span> fix_identifier (in_identifier <\/span>IN<\/span> <\/span>VARCHAR2<\/span>) <\/span>RETURN<\/span> <\/span>VARCHAR2<\/span> <\/span>IS<\/span><\/span>\n      l_identifier <\/span>VARCHAR2<\/span>(<\/span>128<\/span> <\/span>CHAR<\/span>);<\/span><\/span>\n   <\/span>BEGIN<\/span><\/span>\n      <\/span>IF<\/span> in_identifier <\/span>LIKE<\/span> <\/span>'"%"'<\/span> <\/span>THEN<\/span><\/span>\n         l_identifier := substr(in_identifier, <\/span>2<\/span>, <\/span>length<\/span>(in_identifier) - <\/span>2<\/span>);<\/span><\/span>\n      <\/span>ELSE<\/span><\/span>\n         l_identifier := <\/span>upper<\/span>(in_identifier);<\/span><\/span>\n      <\/span>END<\/span> <\/span>IF<\/span>;<\/span><\/span>\n      <\/span>RETURN<\/span> l_identifier;<\/span><\/span>\n   <\/span>END<\/span> fix_identifier;<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- possible PL\/SQL units with an accessible_by_clause (optimization step)<\/span><\/span>\n   <\/span>-- false positives when keyword 'accessible' is not used in a accessible_by_clause<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   candidates <\/span>AS<\/span> (<\/span><\/span>\n      <\/span>SELECT<\/span> <\/span>\/*+ no_merge *\/<\/span> <\/span><\/span>\n             s.owner, s.type <\/span>AS<\/span> object_type, s.name <\/span>AS<\/span> object_name, u.oracle_maintained<\/span><\/span>\n        <\/span>FROM<\/span> dba_users u<\/span><\/span>\n        <\/span>JOIN<\/span> dba_source s<\/span><\/span>\n          <\/span>ON<\/span> u.username = s.owner<\/span><\/span>\n       <\/span>WHERE<\/span> s.type <\/span>IN<\/span> (<\/span>'FUNCTION'<\/span>, <\/span>'PROCEDURE'<\/span>, <\/span>'PACKAGE'<\/span>, <\/span>'TYPE'<\/span>)<\/span><\/span>\n         <\/span>AND<\/span> <\/span>lower<\/span>(<\/span>text<\/span>) <\/span>LIKE<\/span> <\/span>'%accessible%'<\/span><\/span>\n       <\/span>GROUP BY<\/span> s.owner, s.type, s.name, u.oracle_maintained<\/span><\/span>\n   ),<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- extend result with source code (unmodified)<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   original_sources <\/span>AS<\/span> (<\/span><\/span>\n      <\/span>SELECT<\/span> <\/span>owner<\/span>, object_type, object_name, oracle_maintained,<\/span><\/span>\n             sys.dbms_metadata.get_ddl(<\/span><\/span>\n                <\/span>schema<\/span>      => <\/span>owner<\/span>,<\/span><\/span>\n                object_type => <\/span>CASE<\/span> object_type<\/span><\/span>\n                                  <\/span>WHEN<\/span> <\/span>'PACKAGE'<\/span> <\/span>THEN<\/span><\/span>\n                                     <\/span>'PACKAGE_SPEC'<\/span><\/span>\n                                  <\/span>WHEN<\/span> <\/span>'TYPE'<\/span> <\/span>THEN<\/span><\/span>\n                                     <\/span>'TYPE_SPEC'<\/span><\/span>\n                                  <\/span>ELSE<\/span> <\/span><\/span>\n                                     object_type<\/span><\/span>\n                               <\/span>END<\/span>,<\/span><\/span>\n                <\/span>name<\/span>        => object_name<\/span><\/span>\n             ) <\/span>AS<\/span> source_code<\/span><\/span>\n        <\/span>FROM<\/span> candidates <\/span><\/span>\n   ),<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- remove comments and string literals from source code to simplify parsing<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   reduced_sources <\/span>AS<\/span> (<\/span><\/span>\n      <\/span>SELECT<\/span> <\/span>owner<\/span>, <\/span><\/span>\n             object_type, <\/span><\/span>\n             object_name,<\/span><\/span>\n             oracle_maintained,<\/span><\/span>\n             remove_all(source_code) <\/span>AS<\/span> source_code<\/span><\/span>\n        <\/span>FROM<\/span> original_sources<\/span><\/span>\n   ),<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- extend result with number of accessible_by_clauses in source<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   counts <\/span>AS<\/span> (<\/span><\/span>\n      <\/span>SELECT<\/span> <\/span>owner<\/span>, <\/span><\/span>\n             object_type, <\/span><\/span>\n             object_name, <\/span><\/span>\n             source_code,<\/span><\/span>\n             oracle_maintained,<\/span><\/span>\n             regexp_count(source_code, <\/span>'accessible\\s+by\\s*\\(.*?\\)'<\/span>, <\/span>1<\/span>, <\/span>'in'<\/span>) accessible_by_count<\/span><\/span>\n        <\/span>FROM<\/span> reduced_sources<\/span><\/span>\n   ),<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- produce a row for every accessor and extend results by accessor related columns<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   procedure_accessors <\/span>AS<\/span> (<\/span><\/span>\n      <\/span>SELECT<\/span> c.owner,<\/span><\/span>\n             c.object_type,<\/span><\/span>\n             c.object_name,<\/span><\/span>\n             c.oracle_maintained,<\/span><\/span>\n             <\/span>upper<\/span>(a.subprogram_type)             <\/span>AS<\/span> subprogram_type,<\/span><\/span>\n             fix_identifier(a.subprogram_name)    <\/span>AS<\/span> <\/span>procedure_name<\/span>,<\/span><\/span>\n             <\/span>coalesce<\/span>(a.subprogram_id, <\/span>0<\/span>)         <\/span>AS<\/span> subprogram_id,<\/span><\/span>\n             <\/span>upper<\/span>(a.accessor_unit_kind)          <\/span>AS<\/span> accessor_unit_kind,<\/span><\/span>\n             fix_identifier(a.accessor_schema)    <\/span>AS<\/span> accessor_schema,<\/span><\/span>\n             fix_identifier(a.accessor_unit_name) <\/span>AS<\/span> accessor_unit_name<\/span><\/span>\n        <\/span>FROM<\/span> counts c<\/span><\/span>\n       <\/span>CROSS JOIN<\/span> JSON_TABLE(<\/span><\/span>\n                get_accessors(c.object_type, c.source_code, c.accessible_by_count), <\/span><\/span>\n                <\/span>'$[*]'<\/span> columns (<\/span><\/span>\n                   subprogram_type <\/span>VARCHAR2<\/span>(<\/span>30<\/span> <\/span>CHAR<\/span>)  <\/span>PATH<\/span> <\/span>'$.type'<\/span>,<\/span><\/span>\n                   subprogram_name <\/span>VARCHAR2<\/span>(<\/span>128<\/span> <\/span>CHAR<\/span>) <\/span>PATH<\/span> <\/span>'$.name'<\/span>,<\/span><\/span>\n                   subprogram_id   <\/span>INTEGER<\/span>            <\/span>PATH<\/span> <\/span>'$.id'<\/span>,<\/span><\/span>\n                   nested <\/span>path<\/span> <\/span>'$.accessors[*]'<\/span> columns (<\/span><\/span>\n                      accessor_unit_kind <\/span>VARCHAR2<\/span>(<\/span>30<\/span> <\/span>CHAR<\/span>)  <\/span>PATH<\/span> <\/span>'$.unit_kind'<\/span>,<\/span><\/span>\n                      accessor_schema    <\/span>VARCHAR2<\/span>(<\/span>128<\/span> <\/span>CHAR<\/span>) <\/span>PATH<\/span> <\/span>'$.schema'<\/span>,<\/span><\/span>\n                      accessor_unit_name <\/span>VARCHAR2<\/span>(<\/span>128<\/span> <\/span>CHAR<\/span>) <\/span>PATH<\/span> <\/span>'$.unit_name'<\/span><\/span>\n                   )<\/span><\/span>\n                )<\/span><\/span>\n             ) a<\/span><\/span>\n       <\/span>WHERE<\/span> c.accessible_by_count > <\/span>0<\/span> <\/span><\/span>\n   ),<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- produce compact accessor column, remove duplicates from overloaded subprograms<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   aggr_procedure_accessors_base <\/span>AS<\/span> (<\/span><\/span>\n      <\/span>SELECT DISTINCT<\/span> <\/span><\/span>\n             <\/span>owner<\/span>, <\/span><\/span>\n             object_type, <\/span><\/span>\n             object_name, <\/span><\/span>\n             <\/span>procedure_name<\/span>,<\/span><\/span>\n             accessor_unit_kind,<\/span><\/span>\n             accessor_schema,<\/span><\/span>\n             accessor_unit_name,<\/span><\/span>\n             <\/span>CASE<\/span><\/span>\n                <\/span>WHEN<\/span> accessor_unit_kind <\/span>IS NOT NULL<\/span> <\/span>THEN<\/span><\/span>\n                   accessor_unit_kind || <\/span>' '<\/span><\/span>\n             <\/span>END<\/span> || <\/span><\/span>\n             <\/span>CASE<\/span><\/span>\n                <\/span>WHEN<\/span> accessor_schema <\/span>IS NOT NULL<\/span> <\/span>THEN<\/span><\/span>\n                   accessor_schema || <\/span>'.'<\/span><\/span>\n             <\/span>END<\/span> ||<\/span><\/span>\n             accessor_unit_name <\/span>AS<\/span> accessor,<\/span><\/span>\n             oracle_maintained<\/span><\/span>\n        <\/span>FROM<\/span> procedure_accessors<\/span><\/span>\n   ),<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   <\/span>-- aggregated result per subprogram with accessor_list containing comma separated list of all accessors<\/span><\/span>\n   <\/span>--<\/span><\/span>\n   aggr_procedure_accessors <\/span>AS<\/span> (<\/span><\/span>\n      <\/span>SELECT<\/span> <\/span>owner<\/span>, <\/span><\/span>\n             object_type, <\/span><\/span>\n             object_name, <\/span><\/span>\n             <\/span>procedure_name<\/span>, <\/span><\/span>\n             listagg (accessor, <\/span>', '<\/span>) <\/span>WITHIN<\/span> <\/span>GROUP<\/span>(<\/span>ORDER BY<\/span> accessor) <\/span>AS<\/span> accessor_list <\/span><\/span>\n        <\/span>FROM<\/span> aggr_procedure_accessors_base<\/span><\/span>\n       <\/span>WHERE<\/span> oracle_maintained = <\/span>'Y'<\/span><\/span>\n       <\/span>GROUP BY<\/span> <\/span>owner<\/span>, object_type, object_name, <\/span>procedure_name<\/span><\/span>\n       <\/span>ORDER BY<\/span> <\/span>owner<\/span>, object_type, object_name, <\/span>procedure_name<\/span><\/span>\n   )<\/span><\/span>\n-- main<\/span><\/span>\nSELECT<\/span> *<\/span><\/span>\n  <\/span>FROM<\/span> aggr_procedure_accessors<\/span><\/span>\n\/<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
<\/a>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<\/code> only 3 result rows are shown. I hope it’s helpful.<\/p>\n\n\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
Owner<\/th>Object Type<\/th>Object Name<\/th>Procedure Name<\/th>Accessor List<\/th>\n<\/tr>\n<\/thead>\n
APEX_050100<\/td>PACKAGE<\/td>WWV_FLOW_ADVISOR_CHECKS_INT<\/td><\/td>WWV_FLOW_ADVISOR_CHECKS_API<\/td>\n<\/tr>\n
APEX_050100<\/td>PACKAGE<\/td>WWV_FLOW_APP_INSTALL_INT<\/td><\/td>WWV_FLOW_IMP_PARSER, WWV_FLOW_PKG_APP_PARSER<\/td>\n<\/tr>\n
APEX_050100<\/td>PACKAGE<\/td>WWV_FLOW_REGION_LIST<\/td><\/td>WWV_FLOW_REGION_NATIVE<\/td>\n<\/tr>\n
APEX_050100<\/td>PACKAGE<\/td>WWV_FLOW_SPATIAL_INT<\/td><\/td>WWV_FLOW_SPATIAL_API<\/td>\n<\/tr>\n
CTXSYS<\/td>PACKAGE<\/td>DRIACCHELP<\/td><\/td>PACKAGE DRIACC<\/td>\n<\/tr>\n
CTXSYS<\/td>PACKAGE<\/td>DRIUTL<\/td>PARSE_OBJECT_NAME<\/td>PACKAGE DRVUTL, PROCEDURE PARSE_OBJECT_NAME<\/td>\n<\/tr>\n
CTXSYS<\/td>PACKAGE<\/td>DRVODM<\/td>SVM_TRAIN<\/td>CTXSYS.CTX_CLS<\/td>\n<\/tr>\n
DVSYS<\/td>PACKAGE<\/td>CONFIGURE_DV_INTERNAL<\/td><\/td>PROCEDURE SYS.CONFIGURE_DV<\/td>\n<\/tr>\n
GSMADMIN_INTERNAL<\/td>PACKAGE<\/td>DBMS_GSM_COMMON<\/td>GETDBPARAMETERNUM<\/td>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<\/td>\n<\/tr>\n
GSMADMIN_INTERNAL<\/td>PACKAGE<\/td>DBMS_GSM_COMMON<\/td>GETDBPARAMETERSTR<\/td>PACKAGE DBMS_GSM_CLOUDADMIN, PACKAGE DBMS_GSM_COMMON, PACKAGE DBMS_GSM_DBADMIN, PACKAGE DBMS_GSM_POOLADMIN, PACKAGE GGSYS.GGSHARDING<\/td>\n<\/tr>\n
GSMADMIN_INTERNAL<\/td>PACKAGE<\/td>DBMS_GSM_COMMON<\/td>RESETDBPARAMETER<\/td>PACKAGE DBMS_GSM_CLOUDADMIN, PACKAGE DBMS_GSM_COMMON, PACKAGE DBMS_GSM_DBADMIN, PACKAGE DBMS_GSM_POOLADMIN, PACKAGE GGSYS.GGSHARDING<\/td>\n<\/tr>\n
GSMADMIN_INTERNAL<\/td>PACKAGE<\/td>DBMS_GSM_COMMON<\/td>SETDBPARAMETER<\/td>PACKAGE DBMS_GSM_CLOUDADMIN, PACKAGE DBMS_GSM_COMMON, PACKAGE DBMS_GSM_DBADMIN, PACKAGE DBMS_GSM_POOLADMIN, PACKAGE GGSYS.GGSHARDING<\/td>\n<\/tr>\n
GSMADMIN_INTERNAL<\/td>PACKAGE<\/td>DBMS_GSM_UTILITY<\/td>GENERATECHANGELOGENTRY<\/td>PACKAGE DBMS_GSM_CLOUDADMIN, PACKAGE DBMS_GSM_COMMON, PACKAGE DBMS_GSM_DBADMIN, PACKAGE DBMS_GSM_POOLADMIN, PACKAGE GGSYS.GGSHARDING<\/td>\n<\/tr>\n
GSMADMIN_INTERNAL<\/td>PACKAGE<\/td>EXCHANGE<\/td><\/td>PACKAGE GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN, PACKAGE SYS.EXCH_TEST<\/td>\n<\/tr>\n
SYS<\/td>FUNCTION<\/td>ISXMLTYPETABLE_INTERNAL<\/td><\/td>ISXMLTYPETABLE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>CDBVIEW_INTERNAL<\/td><\/td>PACKAGE SYS.CDBVIEW<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_AQADM_INV<\/td><\/td>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<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_AQADM_SYSCALLS<\/td><\/td>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<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_AWR_PROTECTED<\/td><\/td>DBMS_AWR_REPORT_LAYOUT, DBMS_SWRF_REPORT_INTERNAL<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_EXPORT_EXTENSION_I<\/td><\/td>PACKAGE SYS.DBMS_EXPORT_EXTENSION<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_ISCHED_CHAIN_CONDITION<\/td>DELETE_STEP_NAME_TABLE<\/td>PACKAGE DBMS_ISCHED<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_JSON0<\/td><\/td>PACKAGE XDB.DBMS_JSON<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_METADATA_UTIL<\/td>SET_MARKER<\/td>PACKAGE SYS.DBMS_METADATA_INT<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_MVIEW_STATS_INTERNAL<\/td><\/td>DBMS_MVIEW_STATS<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_PCLXUTIL_INTERNAL<\/td><\/td>PACKAGE SYS.DBMS_PCLXUTIL<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_PLUGTS<\/td>PLTS_NEWDATAFILE<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_RAT_MASK_INTERNAL<\/td><\/td>SYS.DBMS_RAT_MASK<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_RECO_SCRIPT_INT<\/td><\/td>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<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_RESULT_CACHE_INTERNAL<\/td><\/td>DBMS_NETWORK_ACL_ADMIN, RC_INTERNAL_TEST<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_SNAPSHOT_KKXRCA<\/td><\/td>PACKAGE DBMS_SNAPSHOT<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_SODA_UTIL<\/td><\/td>PACKAGE SYS.DBMS_SODA, PACKAGE XDB.DBMS_SODA_ADMIN, PACKAGE XDB.DBMS_SODA_DML, PACKAGE XDB.DBMS_SODA_DOM<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_SQLTUNE_INTERNAL<\/td>EXEC_EMX_TUNING_TASK_CALLOUT<\/td>TYPE SYS.WRI$_REPT_SQLT<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_SQLTUNE_INTERNAL<\/td>I_PROCESS_SQL<\/td>PACKAGE SYS.DBMS_SQLDIAG, PACKAGE SYS.DBMS_SQLTCB_INTERNAL, PACKAGE SYS.DBMS_STATS_INTERNAL, PACKAGE SYS.DBMS_WORKLOAD_REPLAY_I, PACKAGE SYS.DBMS_XPLAN<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_SQLTUNE_INTERNAL<\/td>TEST_PROCESS_SQLSET<\/td>PACKAGE SYS.DBMS_STATS<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_SQLTUNE_UTIL0<\/td>CHECK_DV_ACCESS<\/td>PACKAGE SYS.DBMS_SQLTUNE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_SQLTUNE_UTIL1<\/td>GET_SEQ_REMOTE<\/td>PACKAGE SYS.DBMS_SQLTUNE_INTERNAL<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_STATS_INTERNAL<\/td>CREATE_TEMP<\/td>PACKAGE DBMS_STATS<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_STATS_INTERNAL<\/td>POPULATE_TEMP_INSERT<\/td>PACKAGE DBMS_STATS<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_STATS_INTERNAL_AGG<\/td><\/td>PACKAGE DBMS_STATS, PACKAGE DBMS_STATS_INTERNAL<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_STREAMS_ADM_UTL_INT<\/td><\/td>SYS.DBMS_STREAMS_ADM_UTL, SYS.DBMS_STREAMS_MT<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_STREAMS_RPC<\/td>REMOVE_FILE_RC<\/td>REMOVE_FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_STREAMS_TBS_INT<\/td><\/td>DBMS_FILE_GROUP_UTL_INVOK, DBMS_STREAMS_ADM_UTL, DBMS_STREAMS_MT, DBMS_STREAMS_RPC, DBMS_STREAMS_TABLESPACE_ADM, DBMS_STREAMS_TBS_INT_INVOK<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_SUMVDM<\/td><\/td>DBMS_DIMENSION, DBMS_SUMMARY<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_SYNC_REFRESH_INTERNAL<\/td><\/td>DBMS_SYNC_REFRESH<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_TRANSFORM_INTERNAL<\/td><\/td>PACKAGE SYS.DBMS_TRANSFORM, SYS.DBMS_AQADM, SYS.DBMS_TRANSFORM_EXIMP, SYS.DBMS_TRANSFORM_EXIMP_INTERNAL<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_TTS<\/td>CONVERTENCRYPTEDDATAFILECOPY<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_TTS<\/td>GET_AFN_DBID<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_TTS<\/td>GET_AFN_DBIDXENDIAN<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_TTS<\/td>PUT_PROTECTED_TSE_KEY<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_UMF_PROTECTED<\/td><\/td>DBMS_ASH_INTERNAL, DBMS_AWR_REPORT_LAYOUT, DBMS_SWRF_REPORT_INTERNAL, DBMS_WORKLOAD_REPOSITORY<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_WRR_PROTECTED<\/td><\/td>DBMS_RAT_MASK_INTERNAL, DBMS_WORKLOAD_CAPTURE, DBMS_WORKLOAD_REPLAY, DBMS_WORKLOAD_REPLAY_I<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_XDB_UTIL<\/td><\/td>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<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>DBMS_XDS_INT<\/td><\/td>PACKAGE SYS.DBMS_XDS<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPC$QUEUE_INT<\/td>PREPARE_QUEUE_TABLE<\/td>PACKAGE SYS.KUPV$FT_INT<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPC$QUEUE_INT<\/td>SET_DEBUG<\/td>PACKAGE SYS.KUPP$PROC<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPC$QUE_INT<\/td>PREPARE_QUEUE_TABLE<\/td>PACKAGE SYS.KUPC$QUEUE_INT<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPC$QUE_INT<\/td>SET_DEBUG<\/td>PACKAGE SYS.KUPC$QUEUE_INT<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPD$DATA<\/td>SET_DEBUG<\/td>PACKAGE SYS.KUPP$PROC<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPD$DATA_INT<\/td>GET_OPT_PARAM<\/td>PACKAGE KUPD$DATA<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>ADD_DEVICE<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>ADD_FILE<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>ALLOCATE_DEVICE<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>CHECK_FATAL_ERROR<\/td>PACKAGE SYS.KUPD$DATA<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>CLOSE_CONTEXT<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>DELETE_UNUSED_FILE_REFS<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>FILE_REQUEST<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>FILE_REQUEST_NAK<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>FLUSH_LOB<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>GET_BLKBUF_SIZES<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>GET_DEFAULT_FILENAME<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>GET_DUMPFILE_INFO<\/td>PACKAGE SYS.DBMS_DATAPUMP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>GET_FILE_LIST<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>GET_FORMATTED_TIME<\/td>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<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>GET_FULL_FILENAME<\/td>PACKAGE SYS.DBMS_DATAPUMP, PACKAGE SYS.DBMS_DATAPUMP_INT, PACKAGE SYS.DBMS_DATAPUMP_UTL<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>GET_MAX_CSWIDTH<\/td>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<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>INIT<\/td>PACKAGE SYS.KUPM$MCP, PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>INIT_TDX_STATS<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>IS_DUMPFILE_SET_CONSISTENT<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>JOB_MODES<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>LOCATE_MASTER<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>MARK_FILES_AS_UNUSABLE<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>MASTER_TABLE_UNLOAD_STARTED<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>OPEN_CONTEXT<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>READ_LOB<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>RELEASE_FILES<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>RESET_EOF<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>SET_DEBUG<\/td>PACKAGE SYS.KUPP$PROC<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>TERM<\/td>PACKAGE SYS.KUPM$MCP, PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>TRACE<\/td>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<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>VERIFY_DUMPFILE_SET<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE<\/td>WRITE_LOB<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>CLOSE_CONTEXT<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>CREATE_DUMP_FILE<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>CREATE_KEY_INFO<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>DELETE_DUMP_FILE<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>ENCODE_PWD<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>EXAMINE_DUMP_FILE<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>FLUSH_LOB<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>GET_BLKBUF_SIZES<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>GET_DEBUG_EVENT<\/td>PACKAGE SYS.KUPF$FILE, PACKAGE SYS.UTL_XML<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>GET_DEFAULT_CREDENTIAL<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>GET_DEFAULT_FILENAME<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>GET_ENCODED_PWD<\/td>PACKAGE SYS.KUPF$FILE, PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>GET_FORMATTED_TIME<\/td>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<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>GET_FULL_FILENAME<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>GET_MAX_CSWIDTH<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>GTOP<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>INIT<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>IS_DUMPFILE_A_RESTFILE<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>OPEN_CONTEXT<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>PARSE_FILENAME<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>READ_LOB<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>RELEASE_FILES<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>SET_DEBUG<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>SET_TRANS_PARAMS<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>TERM<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>VERIFY_KEY_INFO<\/td>PACKAGE SYS.KUPF$FILE, PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPF$FILE_INT<\/td>WRITE_LOB<\/td>PACKAGE SYS.KUPF$FILE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPM$MCP<\/td>CLOSE_JOB<\/td>PACKAGE SYS.DBMS_DATAPUMP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPM$MCP<\/td>DISPATCH<\/td>PACKAGE SYS.KUPC$QUEUE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPM$MCP<\/td>SET_DEBUG<\/td>PACKAGE SYS.KUPP$PROC<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPP$PROC<\/td>CREATE_MASTER_PROCESS<\/td>PACKAGE SYS.KUPV$FT<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPP$PROC<\/td>CREATE_WORKER_PROCESSES<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPU$UTILITIES<\/td>GET_REMOTE_DBLINK_USER<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPU$UTILITIES<\/td>REPLACE_XML_VALUES<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPU$UTILITIES_INT<\/td>CHECK_TBS_FOR_TDECOL_TABS<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPU$UTILITIES_INT<\/td>CREATE_DIRECTORY<\/td>PACKAGE SYS.DBMS_DATAPUMP_UTL<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPU$UTILITIES_INT<\/td>DEBUG<\/td>PACKAGE SYS.KUPU$UTILITIES<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPU$UTILITIES_INT<\/td>DIRECTORY_SCAN<\/td>PACKAGE SYS.DBMS_PLUGTS, PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPU$UTILITIES_INT<\/td>GET_DP_UPDATE_LOCK<\/td>PACKAGE SYS.DBMS_METADATA, PACKAGE SYS.DBMS_METADATA_DIFF, PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPU$UTILITIES_INT<\/td>GET_PARAMETER_VALUE<\/td>PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPU$UTILITIES_INT<\/td>GET_REMOTE_DBLINK_USER<\/td>PACKAGE SYS.KUPU$UTILITIES<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPU$UTILITIES_INT<\/td>INTALGCONV<\/td>PACKAGE SYS.DBMS_METADATA_UTIL, PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPU$UTILITIES_INT<\/td>RELEASE_DP_UPDATE_LOCK<\/td>PACKAGE SYS.DBMS_METADATA, PACKAGE SYS.DBMS_METADATA_DIFF, PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPU$UTILITIES_INT<\/td>SET_DEBUG<\/td>PACKAGE SYS.KUPP$PROC<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPV$FT<\/td>ATTACH_JOB<\/td>PACKAGE SYS.DBMS_DATAPUMP, PACKAGE SYS.KUPM$MCP, PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPV$FT<\/td>OPEN_JOB<\/td>PACKAGE SYS.DBMS_DATAPUMP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPV$FT_INT<\/td>ACTIVE_CLIENT_COUNT<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPV$FT_INT<\/td>BUILD_MTABLE_INDEXES<\/td>PACKAGE SYS.KUPM$MCP<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPV$FT_INT<\/td>CREATE_NEW_JOB<\/td>PACKAGE SYS.KUPV$FT<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPV$FT_INT<\/td>DEBUG_ENABLED<\/td>PACKAGE SYS.KUPV$FT<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPV$FT_INT<\/td>GET_DEBUG_INFO<\/td>PACKAGE SYS.KUPV$FT<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPV$FT_INT<\/td>ON_BEHALF<\/td>PACKAGE SYS.KUPV$FT<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPV$FT_INT<\/td>SET_DEBUG<\/td>PACKAGE SYS.KUPP$PROC<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPV$FT_INT<\/td>SET_EVENT<\/td>PACKAGE SYS.KUPC$QUE_INT, PACKAGE SYS.KUPD$DATA, PACKAGE SYS.KUPP$PROC, PACKAGE SYS.KUPW$WORKER<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>KUPW$WORKER<\/td>SET_DEBUG<\/td>PACKAGE SYS.KUPP$PROC<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>OUTLN_PKG_INTERNAL<\/td><\/td>PACKAGE SYS.OUTLN_PKG<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>PRVT_ACCESS_ADVISOR<\/td>SETUP_USER<\/td>PACKAGE PRVT_ADVISOR<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>UTL_XML<\/td>PARSEEXPR<\/td>PACKAGE SYS.DBMS_METADATA<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>UTL_XML<\/td>PARSEQUERY<\/td>PACKAGE SYS.DBMS_METADATA<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>WWV_DBMS_SQL_APEX_050100<\/td><\/td>APEX_050100.WWV_FLOW_DYNAMIC_EXEC, APEX_050100.WWV_FLOW_SESSION_RAS, APEX_050100.WWV_FLOW_UPGRADE<\/td>\n<\/tr>\n
SYS<\/td>PACKAGE<\/td>XS_DATA_SECURITY_UTIL_INT<\/td><\/td>PACKAGE XS_DATA_SECURITY_UTIL<\/td>\n<\/tr>\n
SYS<\/td>PROCEDURE<\/td>EXECASUSER<\/td><\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTADM<\/td><\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTAQ<\/td><\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTDDL<\/td><\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTDTRG<\/td><\/td>PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.UD_TRIGS, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTPRIV<\/td><\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTRIC<\/td>GETVARIABLE_C<\/td>PACKAGE WMSYS.OWM_DYNSQL_ACCESS<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTRIC<\/td>SETVARIABLE<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTRIC<\/td><\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ADDUSERDEFINEDHINT<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ADDWCP<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ALLOCATE_UNIQUE<\/td>PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ALLOWROWLEVELLOCKING<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>CHECKADDTOPOGEOLAYERERRORS<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>CHECKDELTOPOGEOLAYERERRORS<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>CHECKDOMAININDEXPRIVS<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>CLEANUPBDDL<\/td>PACKAGE WMSYS.OWM_DDL_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>CLEANUPCDDL<\/td>PACKAGE WMSYS.OWM_DDL_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>CLEANUPDV<\/td>PACKAGE WMSYS.LTDDL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>CLEANUPEV<\/td>PACKAGE WMSYS.LTDDL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>CLEANUPMETADATA<\/td>PACKAGE WMSYS.LTDDL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>CLEANUPMETADATABYUSER<\/td>PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_DYNSQL_ACCESS<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>CLEANUPSTALEMETADATA<\/td>PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>CREATEINLISTFROMQUERY<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>CREATEPKWHERECLAUSE<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>DELETEFULLROLLBACKMARKER<\/td>PACKAGE WMSYS.LT_CTX_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>DELETEUNDOCODE<\/td>PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_BULK_LOAD_PKG, PACKAGE WMSYS.OWM_DDL_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>DELETEUNDOCODECHECKPOINTS<\/td>PACKAGE WMSYS.LT_CTX_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>DELETEUNDOCODERANGE<\/td>PACKAGE WMSYS.LTDDL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>DISALLOWIFWITHVT<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>EXECEVUNDO<\/td>PACKAGE WMSYS.LTDDL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>EXECLOG<\/td>PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>EXECUTESQLLOG<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_MIG_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>EXISTSBIR<\/td>PACKAGE WMSYS.LTRIC<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>EXISTSBUR<\/td>PACKAGE WMSYS.LTRIC<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>EXISTSCONSTRAINT<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>EXISTSFULLROLLBACKMARKER<\/td>PACKAGE WMSYS.LTDDL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>EXISTSTOPOLOGY<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>FIXTOPOLOGYIMPORT<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>FIXVTAB_COMPRESS<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>FIXVTAB_REFRESH<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>FIXVTAB_ROLLBACK<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GENFIXCRNONSEQNFRESHINS<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GENWMCOLSUPDATESTMNT<\/td>PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETBASETABLENAME<\/td>PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETBATCHWHERECLAUSES<\/td>PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_DYNSQL_ACCESS<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETCOLINFO<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_IEXP_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETCOLLIST<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETCOLSTR<\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETCOLUMNPLUSEXPRESSION<\/td>PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETCRSTATUS<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_BULK_LOAD_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETCURRENTLOCKINGMODE<\/td>PACKAGE WMSYS.LT_CTX_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETCURVER<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_IEXP_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETDISTINCTOBJECT<\/td>PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETDISVER<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETHISTOPTION<\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETINDEXTABLE<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTDTRG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETINDEXTABLESPACE<\/td>PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETNESTEDCOLUMNVIEW<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETNESTEDTABLECOLSTR<\/td>PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETNESTEDTABLEMETADATACOLUMNS<\/td>PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETNESTEDTABLETYPE<\/td>PACKAGE WMSYS.OWM_DDL_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETNEXTVERSION<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETNOTNULLCONSTRAINT<\/td>PACKAGE WMSYS.OWM_DDL_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETNTPKEYCOLS<\/td>PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_MP_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETPKEYINFO<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETPKEYINFO_VT<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETPKINDEXINFO<\/td>PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETRLSWHERECLAUSE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETSEQUENCEOPTIONS<\/td>PACKAGE WMSYS.OWM_DDL_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETSID<\/td>PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LT_CTX_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETSNO<\/td>PACKAGE WMSYS.LT_CTX_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETSPACEUSAGE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETTABLETABLESPACE<\/td>PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_DDL_PKG, WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETTOPOFEATURETABINFO<\/td>PACKAGE WMSYS.LTDTRG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETTOPOINFO<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETTRIGGERS<\/td>PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETUDHINT<\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETUNDOCODECLOB<\/td>PACKAGE WMSYS.OWM_BULK_LOAD_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETVALIDTIMEOPTION<\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETVARIABLE_R<\/td>PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETVERINDEXNAME<\/td>PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_IEXP_PKG, PACKAGE WMSYS.OWM_MP_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETVTID<\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETWHERECLAUSESTR<\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETWORKSPACELOCKID<\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GETWORKSPACELOCKMODE<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GET_EXPANDED_NEXTVERS_NP<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>GRANTOLSPRIVS<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>HASCRCHILD<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTRIC<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>HASDEFERREDCHILD<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>HASFEATURETABLE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>HASNESTEDTABLECOLUMN<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>HASOLSPOLICY<\/td>PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>HASRICCASCADINGCONSTRAINT<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>HASRICSETNULLCONSTRAINT<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>HASVIRTUALCOLUMN<\/td>PACKAGE WMSYS.LTDTRG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>HASWOOVERWRITEOPTION<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTRIC<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>HISTWITHDATETYPE<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>HISTWITHDATETYPEEV<\/td>PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>INSERTFULLROLLBACKMARKER<\/td>PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LT_CTX_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>INVERSIONEDSTATE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ISIMPLICITSP<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ISLEAFSTATE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ISMODIFIED<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ISMODIFIEDINSUBTREE<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_DYNSQL_ACCESS<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ISOBJECTTABLE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ISSPATIALINSTALLED<\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ISSPLITINSUBTREE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ISTOPOFEATURETABLE<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ISTOPOLOGYINDEXTABLE<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LT_EXPORT_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ISTOPOLOGYRELATIONTABLE<\/td>PACKAGE WMSYS.LTDTRG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ISVERSIONEDTABLE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ISVERSIONENABLEDTOPOLOGY<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>ISWORKSPACEOWNER<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>MOVEWMMETADATA<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>NEEDTOEXECUTETRIGGERS<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>NUMTRIGGERSTOEXECUTE<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>PARSESTRINGLIST<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>POPULATEROWIDRANGES<\/td>PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>PREFIXSTR<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>QB_BLOCK_REPLACE<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>REMOVEUSERDEFINEDHINT<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>RENAMESAVEPOINT<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>RENAMEWORKSPACE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>REQUIRESTRIGGERSONTOPVIEW<\/td>PACKAGE WMSYS.LTDTRG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>RESETALLSEQUENCES<\/td>PACKAGE WMSYS.LT_EXPORT_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>RESOLVESYNONYM<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>RESTARTSEQUENCE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>SEPARATECLOBINTO2PARTS<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>SETVARIABLE<\/td>PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>TOPOTABLECHECK<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>TO_CLOB_<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>UPDATESDOTOPOMETADATADV<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>UPDATESDOTOPOMETADATAEV<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>WM$GETDBCOMPATIBLESTR<\/td>PACKAGE WMSYS.OWM_IEXP_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LTUTIL<\/td>WRITETOLOG<\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>ALLOWDDLOPERATION<\/td>PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>CHVLTL<\/td>PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>GETLTTABLENAME<\/td>WMSYS.LTDTRG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>GETMULTIWORKSPACES<\/td>WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>GETPURGEOPTION<\/td>PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.WM_DDL_UTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>GETSESSIONATTRIBUTES<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LT_EXPORT_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>GETVARIABLE_B<\/td>PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>GETVARIABLE_N<\/td>PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTDTRG, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.OWM_DYNSQL_ACCESS<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>GETVARIABLE_V<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTAQ, PACKAGE WMSYS.LTUTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>GETVTTABLENAME<\/td>WMSYS.LTDTRG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETACTIVETIMEFORDML<\/td>WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETCALLSTACKASINVALID<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETCALLSTACKASVALID<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.LT_EXPORT_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETCOMMITVARS<\/td>WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETCOMPRESSWORKSPACE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETCONFLICTSTATE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETCOPYVARS<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETDIFFVERS<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETFLIPVERSIONONREFRESH<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETFREEZESTATUS<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETIMPORTVARS<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_DYNSQL_ACCESS<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETINSTANT<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_IEXP_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETLOCKMODE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETMPROOT<\/td>PACKAGE WMSYS.OWM_MP_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETMPWORKSPACE<\/td>PACKAGE WMSYS.OWM_MP_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETMULTIWORKSPACES<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETNEWMPVARS<\/td>PACKAGE WMSYS.OWM_MP_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETNEWROOTANCVERSION<\/td>PACKAGE WMSYS.OWM_MP_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETOPCONTEXT<\/td>PACKAGE WMSYS.LTUTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETPOSTVARS<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETROWLOCKSTATUS<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETSAVEPOINT<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETSTATEATTRIBUTES<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETTABMRGWOREMOVEEVENT<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETTABMRGWREMOVEEVENT<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETTABREFRESHEVENT<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETTRIGGEREVENT<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETTSINSTANT<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETUSER<\/td>PACKAGE WMSYS.LTPRIV<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETVALIDTIME<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETVALIDTIMEFILTEROFF<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETVALIDTIMEFILTERON<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETVARIABLE<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTUTIL, PACKAGE WMSYS.OWM_IEXP_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETVERAFTINSTANT<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETVERBEFINSTANT<\/td>PACKAGE WMSYS.LTADM<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETVERSION<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_IEXP_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETVERSIONANDSTATE<\/td>PACKAGE WMSYS.OWM_IEXP_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETWRITERSTATE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETWSPCMRGWOREMOVEEVENT<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>SETWSPCMRGWREMOVEEVENT<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>TO_TIMESTAMP_TZ_<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>UNSETCOMMITVARS<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>UNSETCOPYVARS<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>UNSETIMPORTVARS<\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_DYNSQL_ACCESS<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_CTX_PKG<\/td>UNSETPOSTVARS<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>LT_EXPORT_PKG<\/td>EXPORT_SCHEMAS<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>OWM_ASSERT_PKG<\/td><\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>OWM_BULK_LOAD_PKG<\/td><\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.OWM_DYNSQL_ACCESS<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>OWM_CPKG_PKG<\/td><\/td>PACKAGE WMSYS.LTDDL, PACKAGE WMSYS.OWM_DYNSQL_ACCESS, PACKAGE WMSYS.OWM_MIG_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>OWM_DDL_PKG<\/td><\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>OWM_DML_PKG<\/td><\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>OWM_IEXP_PKG<\/td><\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.OWM_DYNSQL_ACCESS<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>OWM_MIG_PKG<\/td>RECOVERMIGRATINGTABLE<\/td>PACKAGE WMSYS.LT<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>OWM_MP_PKG<\/td><\/td>PACKAGE WMSYS.LT, PACKAGE WMSYS.LTADM, PACKAGE WMSYS.LTPRIV, PACKAGE WMSYS.LTRIC, PACKAGE WMSYS.OWM_DDL_PKG, PACKAGE WMSYS.OWM_DYNSQL_ACCESS<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>OWM_VSCRIPT_PKG<\/td>STARTQUEUE<\/td>PACKAGE WMSYS.LT_EXPORT_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>OWM_VSCRIPT_PKG<\/td>STOPQUEUE<\/td>PACKAGE WMSYS.LT_EXPORT_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>OWM_VSCRIPT_PKG<\/td>WM$CONVERTVERSIONSTR<\/td>PACKAGE WMSYS.LTUTIL<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>OWM_VSCRIPT_PKG<\/td>WM$GETDBPARAMETER<\/td>PACKAGE WMSYS.LT_CTX_PKG<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>UD_TRIGS<\/td><\/td>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<\/td>\n<\/tr>\n
WMSYS<\/td>PACKAGE<\/td>WM_DDL_UTIL<\/td><\/td>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<\/td>\n<\/tr>\n
XDB<\/td>PACKAGE<\/td>DBMS_CLOBUTIL<\/td><\/td>PACKAGE XDB.DBMS_XMLDOM, PACKAGE XDB.DBMS_XMLPARSER, PACKAGE XDB.DBMS_XSLPROCESSOR<\/td>\n<\/tr>\n
XDB<\/td>PACKAGE<\/td>DBMS_JSON_INT<\/td><\/td>PACKAGE XDB.DBMS_JSON<\/td>\n<\/tr>\n
XDB<\/td>PACKAGE<\/td>DBMS_SODA_DML<\/td><\/td>PACKAGE XDB.DBMS_SODA_ADMIN<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
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.<\/em><\/p>\n\n\n\n
Updated on 2018-05-02: amended query to improve multi-line comments and string literals handling (thanks to Jacek G\u0119bal)<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"
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 [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":9523,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[106,13,85],"class_list":["post-8230","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-accessible_by_clause","tag-plsql","tag-sql"],"yoast_head":"\nAccessible PL\/SQL Programs in Oracle Database 18c - Philipp Salvisberg's Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Accessible PL\/SQL Programs in Oracle Database 18c - Philipp Salvisberg's Blog\" \/>\n<meta property=\"og:description\" content=\"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 [\u2026]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/\" \/>\n<meta property=\"og:site_name\" content=\"Philipp Salvisberg's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-30T16:10:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-08T00:25:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2018\/05\/accessible_by_clause.png\" \/>\n\t<meta property=\"og:image:width\" content=\"574\" \/>\n\t<meta property=\"og:image:height\" content=\"453\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Philipp Salvisberg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:site\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Philipp Salvisberg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/04\\\/30\\\/accessible-pl-sql-programs-in-oracle-database-18c\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/04\\\/30\\\/accessible-pl-sql-programs-in-oracle-database-18c\\\/\"},\"author\":{\"name\":\"Philipp Salvisberg\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"headline\":\"Accessible PL\\\/SQL Programs in Oracle Database 18c\",\"datePublished\":\"2018-04-30T16:10:41+00:00\",\"dateModified\":\"2023-11-08T00:25:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/04\\\/30\\\/accessible-pl-sql-programs-in-oracle-database-18c\\\/\"},\"wordCount\":451,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/04\\\/30\\\/accessible-pl-sql-programs-in-oracle-database-18c\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/accessible_by_clause.png\",\"keywords\":[\"accessible_by_clause\",\"PL\\\/SQL\",\"SQL\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/04\\\/30\\\/accessible-pl-sql-programs-in-oracle-database-18c\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/04\\\/30\\\/accessible-pl-sql-programs-in-oracle-database-18c\\\/\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/04\\\/30\\\/accessible-pl-sql-programs-in-oracle-database-18c\\\/\",\"name\":\"Accessible PL\\\/SQL Programs in Oracle Database 18c - Philipp Salvisberg's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/04\\\/30\\\/accessible-pl-sql-programs-in-oracle-database-18c\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/04\\\/30\\\/accessible-pl-sql-programs-in-oracle-database-18c\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/accessible_by_clause.png\",\"datePublished\":\"2018-04-30T16:10:41+00:00\",\"dateModified\":\"2023-11-08T00:25:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/04\\\/30\\\/accessible-pl-sql-programs-in-oracle-database-18c\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/04\\\/30\\\/accessible-pl-sql-programs-in-oracle-database-18c\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/04\\\/30\\\/accessible-pl-sql-programs-in-oracle-database-18c\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/accessible_by_clause.png\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/accessible_by_clause.png\",\"width\":574,\"height\":453},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2018\\\/04\\\/30\\\/accessible-pl-sql-programs-in-oracle-database-18c\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Accessible PL\\\/SQL Programs in Oracle Database 18c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\",\"name\":\"Philipp Salvisberg's Blog\",\"description\":\"Database-centric development\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\",\"name\":\"Philipp Salvisberg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"width\":400,\"height\":400,\"caption\":\"Philipp Salvisberg\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\"},\"sameAs\":[\"http:\\\/\\\/www.salvis.com\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Accessible PL\/SQL Programs in Oracle Database 18c - Philipp Salvisberg's Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/","og_locale":"en_US","og_type":"article","og_title":"Accessible PL\/SQL Programs in Oracle Database 18c - Philipp Salvisberg's Blog","og_description":"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 [\u2026]","og_url":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/","og_site_name":"Philipp Salvisberg's Blog","article_published_time":"2018-04-30T16:10:41+00:00","article_modified_time":"2023-11-08T00:25:35+00:00","og_image":[{"width":574,"height":453,"url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2018\/05\/accessible_by_clause.png","type":"image\/png"}],"author":"Philipp Salvisberg","twitter_card":"summary_large_image","twitter_creator":"@phsalvisberg","twitter_site":"@phsalvisberg","twitter_misc":{"Written by":"Philipp Salvisberg","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/#article","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/"},"author":{"name":"Philipp Salvisberg","@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"headline":"Accessible PL\/SQL Programs in Oracle Database 18c","datePublished":"2018-04-30T16:10:41+00:00","dateModified":"2023-11-08T00:25:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/"},"wordCount":451,"commentCount":0,"publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2018\/05\/accessible_by_clause.png","keywords":["accessible_by_clause","PL\/SQL","SQL"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/","url":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/","name":"Accessible PL\/SQL Programs in Oracle Database 18c - Philipp Salvisberg's Blog","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/#primaryimage"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2018\/05\/accessible_by_clause.png","datePublished":"2018-04-30T16:10:41+00:00","dateModified":"2023-11-08T00:25:35+00:00","breadcrumb":{"@id":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/#primaryimage","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2018\/05\/accessible_by_clause.png","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2018\/05\/accessible_by_clause.png","width":574,"height":453},{"@type":"BreadcrumbList","@id":"https:\/\/www.salvis.com\/blog\/2018\/04\/30\/accessible-pl-sql-programs-in-oracle-database-18c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.salvis.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Accessible PL\/SQL Programs in Oracle Database 18c"}]},{"@type":"WebSite","@id":"https:\/\/www.salvis.com\/blog\/#website","url":"https:\/\/www.salvis.com\/blog\/","name":"Philipp Salvisberg's Blog","description":"Database-centric development","publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.salvis.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515","name":"Philipp Salvisberg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","width":400,"height":400,"caption":"Philipp Salvisberg"},"logo":{"@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg"},"sameAs":["http:\/\/www.salvis.com\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/8230","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/comments?post=8230"}],"version-history":[{"count":30,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/8230\/revisions"}],"predecessor-version":[{"id":12630,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/8230\/revisions\/12630"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media\/9523"}],"wp:attachment":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media?parent=8230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/categories?post=8230"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/tags?post=8230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
The accessible_by_clause<\/a><\/code> on line 13 restricts the access of the procedure parseQuery<\/code> to the package SYS.DBMS_METADATA<\/code>. It looks like Oracle started to use this 12.1 feature in 12.2 and is tightening its APIs with new releases.<\/p>\n\n\n\n