Home » SQL » How to Compile Invalid Package Body in Oracle 11g

How to Compile Invalid Package Body in Oracle 11g

By

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

Oracle Alter Package Statment

See also:

  1. How to create a procedure inside a Package in Oracle
  2. How to check invalid objects count in Oracle
  3. How to execute a procedure inside a Package.