Answer / guest

Cause: The object type's status is invalid which may be
caused by a dependant type's modification (or removal)
without cascading the change.

Action: The type must be recompiled using ALTER TYPE COMPILE.

Please add more information about this Error

Answer / mayur vora

1. Run following query:

select
'ALTER ' || OBJECT_TYPE || ' ' ||
OWNER || '.' || OBJECT_NAME || ' COMPILE;'
from
dba_objects
where
status = 'INVALID'
and
object_type in ('PACKAGE','FUNCTION','PROCEDURE','TABLE')



2. Now follow below block.

declare
cursor myCursor is select object_type, object_name
from SYS.USER_OBJECTS where status = 'INVALID'
order by 1, 2;
sqlString varchar2(100);
begin
for r1 in myCursor loop
begin
if r1.object_type = 'PACKAGE BODY' then
sqlString := 'alter PACKAGE '||r1.object_name||'
compile BODY';
elsif r1.object_type = 'TYPE BODY' then
sqlString := 'alter TYPE '||r1.object_name||'
compile BODY';
else
sqlString := 'alter '||r1.object_type||'
'||r1.object_name||' compile';
end if;
execute immediate sqlString;
dbms_output.put_line(r1.object_type||'
'||r1.object_name||' compiled successfully');
exception
when OTHERS then
dbms_output.put_line(SQLERRM||' on '||sqlString);
end;

DRG-11726: phrase is not a preferred term

1 Answers  

---

SQL*Loader-00913: Error fetching results of select statement (upi): [number]

1 Answers  

---

ORA-27196: skgfpbk: sbtpcbackup returned error

1 Answers  

---

ORA-12685: Native service required remotely but disabled locally

1 Answers  

---

ORA-09872: TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.

1 Answers  

---

TNS-01407: Status: string Total handlers: string Relevant handlers: string

1 Answers  

---

ORA-12031: cannot use primary key columns from materialized view log on "string"."string"

1 Answers  

---

ORA-08207: ora_addr: cannot open address file

1 Answers  

---

ORA-12214: TNS:missing local communities entry in TNSNAV.ORA

1 Answers  

---

ORA-01339: logfile is too old

1 Answers  

---

ORA-24775: cannot prepare or commit transaction with non-zero lock value

1 Answers  

---

RMAN-06458: AS COPY option cannot be used with RECOVERY FILES, RECOVERY AREA or DB_RECOVERY_FILE_DEST

1 Answers  

---