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' /
Sunday, December 6, 2009
Compile invalid java objects
Comp_java.sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment