DBA Data[Home] [Help]

SYS.VALIDATE_RUL dependencies on ALL_OBJECTS

Line 5: select 1 into retnum from all_objects where

1: procedure validate_rul as
2: retnum NUMBER;
3: begin
4: -- make sure all the objects in EXFSYS schema are valid --
5: select 1 into retnum from all_objects where
6: owner = 'EXFSYS' and status != 'VALID' and rownum < 2;
7:
8: sys.dbms_registry.invalid('RUL');
9: exception