How to Compile Invalid Objects on APPS Schema For Packages & API


How to Compile Invalid Objects on APPS Schema For Packages and APIs-

 

This is an example for OZF – Trade Management Schema

declare
cursor invalid_objects is
select object_name, object_type
from user_objects
where object_type in ('PACKAGE', 'PACKAGE BODY')
and status = 'INVALID'
and object_name like 'OZF%';
begin
for rec in invalid_objects
loop
DBMS_DDL.ALTER_COMPILE (rec.object_type ,'OZF' ,rec.object_name);
end loop;
end;

Advertisements

3 thoughts on “How to Compile Invalid Objects on APPS Schema For Packages & API

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s