search

PhilippSalvisberg / plscope-utils

Utilities for PL/Scope in Oracle Database
Apache License 2.0
35 stars 17 forks source link

Revised fix for issue #47 #50

Closed rvo-cs closed 2 years ago

rvo-cs commented 2 years ago

The new fix consists of the following:

  1. Initially, the plscope_naming view is created without the comments that confuses SQL*Plus
  2. Then we add these comments by creating a regular comment on the view. That's where they belong! (Too bad comments on views are so poorly supported in SQLcl / SQL Developer as of now. :confused:) Remark: the COMMENT statement must be wrapped into a PL/SQL anonymous block due to SQL*Plus limitations.
  3. Finally, another PL/SQL anonymous block is used to inject the comment text into the view, where it stood originally, after the with keyword.

Regards,

PhilippSalvisberg commented 2 years ago

This issue is described in #53 and fixed with PR #54