Skip to Main Content

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!

Error While Recompiling invalid objects

547796Feb 26 2007 — edited Feb 26 2007
Hi Experts,
When i try to recompile invalid objects such as package body

sql> alter package owner.obj_name compile body;

Warning: Package altered with compilation errors.

So can anyone tell me the way to compile without errors and turning the objects from invalid to valid state.Any Help will be appreciated.

Thanks
Senthil
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2007
Added on Feb 26 2007
12 comments
712 views