ALTER TRIGGER my_trigger COMPILE; ALTER VIEW my_view COMPILE; Regards, VijayRaju Was this answer useful? Yes Replysrirama varma Nov 18th, 2006 you will need to recompile the invalid objects in the Repository. Was this answer useful? Yes ReplyDebi Prasad Maharana,Wipro Technologies. Nov...
from sys.dba_objects o, sys.order_object_by_dependency d where o.object_id = d.object_id(+) and o.status = 'INVALID' and o.object_type in ('PACKAGE', 'PACKAGE BODY', 'FUNCTION', 'PROCEDURE', 'TRIGGER', 'VIEW') order by d.dlevel desc, o.object_type) LOOP */ FOR invalid ...
How to Re-Compile All Invalid for Oracle EBS Package/Package Body set serveroutput on size 1000000 declare sql_statement varchar2(200); cursor_id number; ret_val number; CURSOR cur_invalid IS select object_type, owner, object_name from sys.dba_objects o where o.status = 'INVALID' and o...
and o.status = 'INVALID' and o.object_type in ('PACKAGE', 'PACKAGE BODY', 'FUNCTION', 'PROCEDURE', 'TRIGGER', 'VIEW') order by d.dlevel desc, o.object_type) LOOP */ FOR invalid IN cur_invalid LOOP begin ifinvalid.object_type ='PACKAGE BODY'then sql_statement :='alter package ...
and o.object_type in ('PACKAGE', 'PACKAGE BODY', 'FUNCTION', 'PROCEDURE', 'TRIGGER', 'VIEW') order by d.dlevel desc, o.object_type) LOOP */ FOR invalid IN cur_invalid LOOP begin if invalid.object_type = 'PACKAGE BODY' then ...