VIEW: SYS.UTL_RECOMP_INVALID_JAVA_SYN

Source

View Text - Preformatted

SELECT "OBJ#","OWNER","OBJNAME","TYPE#","NAMESPACE","STATUS","EDITION_NAME" FROM utl_recomp_all_objects
   WHERE type# = 5 AND status in (4, 5, 6) AND
         obj# IN (SELECT d.d_obj# FROM obj$ o, dependency$ d
                  WHERE o.obj# = d.p_obj# and o.type# = 29)

View Text - HTML Formatted

SELECT "OBJ#"
, "OWNER"
, "OBJNAME"
, "TYPE#"
, "NAMESPACE"
, "STATUS"
, "EDITION_NAME"
FROM UTL_RECOMP_ALL_OBJECTS
WHERE TYPE# = 5
AND STATUS IN (4
, 5
, 6) AND OBJ# IN (SELECT D.D_OBJ#
FROM OBJ$ O
, DEPENDENCY$ D
WHERE O.OBJ# = D.P_OBJ#
AND O.TYPE# = 29)