plscope-utils

plscope-utils copied to clipboard

lineage_util does not traverse chains of synonyms

2

In keeping with issue #63, chains of synonyms are not traversed by the `lineage_util` package. Reason: `dd_util.resolve_synonym` performs only a "shallow" resolution, as opposed to "in-depth" resolution of chains of...

rvo-cs

SQL Dev extension: No filter on owner of a synonym

5

**Case 1**: for objects of type synonym, the following disjunction voids the filter on `owner` : ``` where (owner = :OBJECT_OWNER or upper(replace(:OBJECT_TYPE, 'plscope-utils-')) = 'SYNONYM') ``` The effect can...

rvo-cs

SQL Dev extension: source text appears as null on the "Used By" tab

1

Actual:  Expected:  Cause: wrong filter applied to `dba_source` / `all_source` The "Text" column is supposed to show the source text in _referencing_ code units, not that...

rvo-cs

SQL Dev extension: plscope-utils tabs are not displayed in the main editors for PL/SQL types

1

E.g. the "Identifiers" tab is shown (as expected) from child nodes of the PL/Scope -> Packages node, but not from child nodes of the main Packages node at schema level,...

rvo-cs

The "Compile with PL/Scope" action should not use dbms_utility.compile_schema

4

As of v1.0.0, the "Compile with PL/Scope" action recompiles PL/SQL code by calling `dbms_utility.compile_schema` [^types_special_case]. Replacing that procedure should be considered, for the following reasons: 1. It's not complete, as...

rvo-cs

SQL Developer extension: add a report for viewing synonyms compiled with/without PL/Scope

2

Synonyms compiled with PL/Scope can be found in sys.plscope\_identifier$, with the following identifying properties: * type# = 37 * symrep = name of the synonym * obj# = object\_id of...

rvo-cs

plscope_tab_usage ignores object tables

1

Example: Using utPLSQL, release 3.1.12, installed in the UT3 schema. ``` exec plscope_context.set_attr('OWNER', 'UT3'); exec plscope_context.set_attr('OBJECT_TYPE', 'PACKAGE BODY'); exec plscope_context.set_attr('OBJECT_NAME', 'UT_SUITE_CACHE_MANAGER'); select line, col, operation, ref_owner, ref_object_type, ref_object_name, direct_dependency, text...

rvo-cs

The "Compile with PL/Scope" action affects only the session user

5

If using an account with DBA privileges, I'd expect to be able to use the "Compile with PL/Scope" action in order to recompile _any_ schema of my own choosing[^expected_restrictions]. This...

rvo-cs

plscope_tab_usage may return duplicate rows

1

Test setup: ``` alter session set current_schema = "SCOTT"; alter session set plscope_settings = "IDENTIFIERS:ALL, STATEMENTS:ALL"; create table ta (id number); create table tb (id number); create or replace view...

rvo-cs

plscope_tab_usage does not always handle synonyms consistently

1

Test setup: ``` alter session set current_schema = "SCOTT"; alter session set plscope_settings = "IDENTIFIERS:ALL, STATEMENTS:ALL"; create table t1 (c1 number); create synonym s_t1 for t1; create view vw_t1 as...

rvo-cs