How to Compile Invalid Package Body in Oracle 11g

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 1 min read

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.