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...
Oracle Answer First Prev Next Last Showing Answers 1 - 6 of 6 AnswersVijayaraju T Nov 7th, 2006 First check all the INVALID objects in the schema using : select OBJECT_NAME,OBJECT_TYPE from user_objects where status='INVALID'; compile the objects accordingly... ALTER PACKAGE my_packag...
Oracle Tools Integration Version 10.1.2.0.2 (Production) Oracle Tools Common Area Version 10.1.2.0.2 Oracle CORE 10.1.0.5.0 Production Compiling library OEXOEBSE... Invalidating Package Spec OE_BSA_WORKFLOW... Invalidating Package Spec OE_BSA_SPECIAL... Invalidating Package Spec OE_BSA_PRICING....
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.SymptomsOn : 11.2.0.4 version, RDBMSInvalid SYS objects cannot be recompiled.The issue started with an alert log messages: ORA-04063: package body "SYS.DBMS_SQLTUNE" has errors...
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 ...
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 ...