Re: 12.2 FNDCPASS Error

Posted by Husain on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/12-2-FNDCPASS-Error-tp3272p3303.html

Erman,

Catalog and Catproc - How to find what Objects are keeping them Invalid in the Registry (dba_registry) (Doc ID 578841.1)

This document updated the CATPROC component(ultrp.sql)

But it doesn't work for CATJAVA.

Below sql result is ;

Please compile Invalid object /b74ccd0_ExecutionAgent1
Object_id 508899

PL/SQL procedure successfully completed.


how to compile this java class????

---------------------------------------------------------
set serveroutput on;
declare
start_time date;
end_time date;
object_name varchar(100);
object_id char(10);
begin
SELECT date_loading, date_loaded into start_time, end_time FROM registry$
WHERE cid = 'CATJAVA';
SELECT obj#,name into object_id,object_name
FROM obj$
WHERE status > 1 AND
(ctime BETWEEN start_time AND end_time OR
mtime BETWEEN start_time AND end_time OR
stime BETWEEN start_time AND end_time) AND
ROWNUM <=1;
dbms_output.put_line('Please compile Invalid object '||object_name||'
Object_id '||object_id );
EXCEPTION
WHEN NO_DATA_FOUND THEN
dbms_output.put_line('CATPROC can be validated now' );
end;
/