SYS.XOQ_VALIDATE dependencies on DBA_LIBRARIES

Line 60: SELECT 0 INTO dummy_num FROM DBA_LIBRARIES

56:
57: IF ok THEN
58: -- check that installed library is valid
59: BEGIN
60: SELECT 0 INTO dummy_num FROM DBA_LIBRARIES
61: WHERE STATUS = 'INVALID' AND rownum <=1 AND
62: OWNER='SYS' AND LIBRARY_NAME = 'DBMS_OLAPI_LIB';
63: -- at least one object is invalid so component is invalid
64: ok := FALSE;