SYS.XOQ_VALIDATE dependencies on DBA_OBJECTS

Line 85: SELECT 0 INTO dummy_num FROM dba_objects

81:
82: IF ok THEN
83: -- check that Java classes are loaded successfully
84: BEGIN
85: SELECT 0 INTO dummy_num FROM dba_objects
86: WHERE owner = 'SYS' AND
87: status = 'INVALID' AND
88: object_type = 'JAVA CLASS' AND
89: object_name LIKE 'oracle/AWXML/%';

Line 102: SELECT 0 INTO dummy_num FROM DBA_OBJECTS

98:
99: IF ok THEN
100: -- check that installed types, packages, and procedures are valid
101: BEGIN
102: SELECT 0 INTO dummy_num FROM DBA_OBJECTS
103: WHERE STATUS = 'INVALID' AND rownum <=1 AND
104: OWNER='SYS' AND OBJECT_NAME IN
105: ('DBMS_CUBE_ADVISE','DBMS_CUBE_ADVISE_SEC','DBMS_CUBE',
106: 'DBMS_CUBE_EXP','GENDATABASEINTERFACE','GENCONNECTIONINTERFACE',