How to order procedures and functions in database package

[sonksen]

Hello

I reverse engineered a database package, from an Oracle8i database, or a script, into a PDM model.
The package has many procedures.
The problem is that QDesigner (Quest's PowerDesigner) v. 9.5 orders the procedures by their name inside the package.
I wanted to maintain the same order like in the database.
I have a procedure in the package body only, that is used by other procedures in the package, and it must appear before the others.
QDesigner is also removing the comments inside the package and package body that are outside of the procedures or functions.

Regards,
Ronald Sönksen

 

[markrem]

The order of procedures in a package is not important to Oracle. Order makes no difference to Oracle. Think about what is cached in your shared pool - the whole package or just the program units most recently used???

As for Quest's product, I do not know how to tell it to stop stipping comments. Sounds like a buggy product.

9i OCP

 

[sonksen]

Hello

If the package body has private functions or procedures, the order is important.

Regards,
Ronald Sönksen