Skip to Main Content
Forums

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!

Compile plsql and object types for debugging

670921Mar 28 2012 — edited Mar 28 2012
I have some packages that use oracle object types. How do I recompile them for debugging in SQL developer? I tried the following command but only worked for some of the packages, which means some packages are compiled with debug info and some are not.

alter package compile debug package


Do I have to recompile the Oracle Object Types for debug using the "alter type" command? Or the recompiling of packages already recompiles the dependent object types?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2012
Added on Mar 28 2012
2 comments
1,213 views