Press "Enter" to skip to content

How to Compile Invalid Package Body in Oracle 11g

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.

Vinish Kapoor

I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me, it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub and get notifications for new posts.

You may also like:

Be First to Comment

    Leave a Reply

    Your email address will not be published. Required fields are marked *