Can't see comments before create or replace package

[gittar29]

I searched and found something sort of relevant but it was from a while ago. Here goes:

I am trying to view a package and body through right click the package and then View Package and Body (object browser). The code has a commented section BEFORE the create or replace package, and the program window is not showing me this. I'm assuming its programmed to just pick up create or replace. Any workaround?

EX:

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

When I open the code I only see the create or replace part and no comments. It seems to only be a problem when opening through the schema browser instead of opening the file directly. Weird.

 

[Bo Pedersen]

When you rigth click in the object browser to view a package, PL/SQL Developer displays the source code that Oracle stores in the database when you compile the package.

The comments before the create statement is not regarded as part of the object by Oracle and hence not stored as part of the object source in the database. Oracle does not store the file. Just the object code.

So always make sure your comments is inside the object code. For a view f.ex. this has to be after the select part.

Bo Pedersen

 

[gittar29]

Bo, thanks for the answer - I figured thats what was happening but just wanted to confirm. Thanks for the response