Use Alter Package statement to compile invalid package body in Oracle 11g. Sometimes package got invalid in Oracle if their dependency objects have been modified or due to errors in the package body.
Alter Package Syntax
Alter Package package_name Compile Body;
Alter Package Example
ALTER PACKAGE emp_pkg COMPILE BODY;
Output
Package altered.
Reference
See also:
- How to create a procedure inside a Package in Oracle
- How to check invalid objects count in Oracle
- How to execute a procedure inside a Package.