Plscope Utils Versions Save

Utilities for PL/Scope in Oracle Database

v1.0.0

1 year ago

New

  • #21 Support sequences in PL/Scope tree (SQLDev)
  • #26 Add column module_name to plscope_identifiers (Core)
  • #39 Various new columns in plscope_identifiers view (Core)
  • #40 Simplify Identifiers editor in SQLDev extension (SQLDev)
  • Remove Primary and Secondary nodes in the PL/Scope tree (SQLDev)
  • Make alle nodes int the PL/Scope tree filterable (SQLDev)

Fixed

  • #20 Wrong icon shown for procedure in PL/Scope tree (SQLDev)
  • #25 Cannot compile package parse_util in Oracle Database 18c (Core)
  • #30 No access to UTL_XML / UTL_XML_LIB in ATP (Core)
  • #33 Loop in Dependency Graph (Core, SQLDev)
  • #39 Forward declarations not considered in procedure_scope of plscope_identifiers (Core)
  • #41 Do not use sys_context('userenv', 'authenticated_identity') for schemas (Core, SQLDev)
  • False naming convention violations (Core, SQLDev)
  • Empty links in editors and reports (SQLDev)

Behind the Scenes

  • #23 Initial JUnit tests for SQL Developer Extension (SQLDev)
  • #22 Initial Unit Tests for Core Database Objects (Core)
  • #31 Test failures when running on 19c PDB (Core)
  • #34 ORA-01489: result of string concatenation is too long (Core, SQLDev)
  • #35 Automatically format all code in this repository (Core)
  • #36 Format SQL and PL/SQL files (Core, SQLDev)
  • Fix Violations of Trivadis PL/SQL & SQL Coding Guidelines
  • Do not use public synonyms that are not compiled with PL/Scope (Core, SQLDev)

v0.6.0

6 years ago

Version 0.6.0

  • New

    • #19 Support report "Unused Local Identifiers" in Oracle Database 11.1 to 12.1
  • Fixed

    • #18 Identifiers view not working on Oracle Database < 12.2

v0.5.2

6 years ago

Version 0.5.2

  • Improved

    • When a usage_id is missing in the hierarchy a suitable alternative is used (see also #17)
  • Fixed

    • #17 Missing row in plscope_identifiers

v0.5.1

6 years ago

Version 0.5.1

  • Fixed
    • #16 Viewers for "Identifiers", "Uses" and "Table Usages" are slow for PDB connections

v0.5.0

6 years ago

Version 0.5.0

  • New
    • #10 Report "Trivadis PL/SQL Naming Conventions"
    • #15 Add viewer "Uses"
  • Fixed
    • #11 Report "CRUD Operations" needs the view plscope_identifiers to be installed
    • #12 Report "UDF Calls in SQL Statements" is slow
    • #13 Report "Unused Local Identifiers" is slow

v0.4.2

6 years ago

Version 0.4.2

  • Fixed
    • #9 12c columns such as ORIGIN_CON_ID must not be selected in 11g queries

v0.4.1

6 years ago

Version 0.4.1

  • Fixed
    • #7 Report "Unused Local Identifiers" uses dba_* views
    • #8 Extension is not loaded in SQL Developer 17.2.0

v0.4.0

6 years ago

Version 0.4.0

  • Initial GA Release
  • Extension for Oracle SQL Developer
    • Adds PL/Scopenode to the database navigator tree
    • Adds Compile with PL/Scope context menu on the connection and PL/Scope node
    • Adds viewers/editors for tables, views and PL/SQL nodes
    • Adds plsql-utils Reports folder
  • Prerequisites
    • Oracle SQL Developer 4.0.0 or higher
    • Oracle Database Server 11g Release 1 or higher

v0.3.0

6 years ago

Version 0.3.0

  • New
    • #4 Add is_used column to plscope_identifiers
    • #5 Add procedure_scope column to plscope_identifiers
  • Fixed
    • #3 Wrong result when PL/Scope hierarchy is inconsistent

v0.2.0

6 years ago

Version 0.2.0

  • New
    • #1 Add dba_source.text column to plscope_identifiers
    • #2 Add parent_statement_type column to plscope_identifiers