Skip to content

The Package Purpose Documentation gets deleted with SQL-Developer #65

@JuergenSchuster

Description

@JuergenSchuster

Hi guys,

there is a new solution out I guess from @RamonEsteveCuevas ? where you can add docu for the purpose of the Package Body. But it is implemented that it gets only retrieved when you start with the comment before the create package body.

This comment is not saved by SQL-Developer. So the Package purpose comment should also be recognised when it comes right after create or replace package body. See attached file:
Package_SQL_Developer.pdf

Additional Information

I spoke to @JuergenSchuster today and here's some additional information on this ticket. His team primarily develops directly in the DB and then exports all the packages into file at the end of each development cycle. Though I don't agree with this practice it's fairly common in the Oracle world.

When developing in the DB anything comments before the create or replace package and after the end; / are saved in the DB. Ex:

/** 
 * Some comments
 */
create or replace package my_pkg 
...

These comments will be lost. Where as

create or replace package my_pkg 
/** 
 * Some comments
 */

...

The comments will be preserved because they reside in the the package.

The issue that needs to be resolved for this ticket is if we can modify the docx engine to view the comments before or after a create or replace package statement and process them in the same fashion.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions