SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generate .pkb and .pkg files from DB Package

594614Oct 15 2009 — edited Oct 15 2009

Env. Oracle 10G

Hello,

We have around 20 packages in our db. While making release in Production we need all packages as .pkb and .pkb. To prepare release we go to each package and copy body contents in .pkb file and specification in .pkg file. This we have to do for each package.

Is there any way so we can automate process of creating .pkb and .pkg for each package. If someone has script or any idea, it would be helpufl.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2009

Added on Oct 15 2009

6 comments

4,467 views