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;
Love reading your blog, always learn random interesting facts.
Emily R. from Husky Training
LikeLike
a handy one
LikeLike