PROCEDURE: SYS.VALIDATE_SDO

Source

1 PROCEDURE      validate_sdo IS
2 cnt number;
3 v_value varchar(64);
4 BEGIN
5 
6     SELECT value INTO  v_value from  v$option WHERE parameter = 'Spatial';
7      if v_value = 'FALSE' then
8        -- set status OPTION OFF
9        sys.dbms_registry.set_rdbms_status('SDO',9);
10        return;
11      end if;
12 
13     select count(*) into cnt from dba_invalid_objects where status = 'INVALID'
14            and OWNER='MDSYS';
15 
16      if cnt > 0 then
17        dbms_registry.invalid('SDO');
18        return;
19      end if;
20 
21     select count(*) into cnt from dba_xml_schemas where OWNER = 'MDSYS';
22 
23      if cnt < 5 then
24        dbms_registry.invalid('SDO');
25        return;
26      end if;
27 
28     dbms_registry.valid('SDO');
29 END;