Sunday, December 6, 2009

Compile invalid java objects

Comp_java.sql


set echo off
set feedback off
set pagesize 0

spool alter_java.sql

select 'ALTER JAVA SOURCE "' || object_name || '" COMPILE;'
from user_objects
where object_type = 'JAVA SOURCE'
and status = 'INVALID'
/

select 'ALTER JAVA CLASS "' || object_name || '" RESOLVE;'
from user_objects
where object_type = 'JAVA CLASS'
and status = 'INVALID'
/

spool off
set feedback on
set pagesize 120
set echo on
@alter_java.sql

Rem This Classes are still INVALID:
set linesize 120
set pagesize 60
col java_class format a80 wrap
select dbms_java.longname(object_name) as "JAVA_CLASS", status
from user_objects
where object_type = 'JAVA CLASS'
and status = 'INVALID'
/

No comments: