Bugfix/various fixes from pull request 38 - Githubissues

PhilippSalvisberg / plscope-utils

Utilities for PL/Scope in Oracle Database

Apache License 2.0

35 stars 17 forks source link

Bugfix/various fixes from pull request 38 #39

Closed PhilippSalvisberg closed 2 years ago

PhilippSalvisberg commented 2 years ago

based on pull request #38 (many thanks to @rvo-cs)
- new features by @rvo-cs
  - column name_usage: shows the name indented by level plus the type and usage in parenthesis. For SQL statements the sql_id is shown in parenthesis.
  - column is_fixed_context_id: YES if it was fixed otherwise null.
  - column procedure_signature: signature of procedure_name otherwise null.
  - column proc_ends_before_line: ending line of procedure/function definition otherwise null.
  - column proc_ends_before_col: ending column of procedure/function definition otherwise null.
  - column ref_line: referenced line of ref_owner/ref_object_type/ref_object_name combination, null if referenced object is null.
  - column ref_col: referenced column of ref_owner/ref_object_type/ref_object_name combination, null if referenced object is null.
- bug fixes by @rvo-cs:
  - column procedure_scope does not consider forward declarations
  - fixes #34: ORA-01489: result of string concatenation is too long
- changes of the original PR
  - reformatted code
  - small rewrites to conform to the Trivadis PL/SQL & SQL Coding Guidelines
  - remove filter on column origin_con_id, see ee61a99
fix test case test_get_view_source (due to usage of lowercase keywords)
updated Arbori program to format recursive query correctly