DBA Data[Home] [Help]

SYS.VALIDATE_SDO dependencies on DBMS_REGISTRY

Line 9: sys.dbms_registry.set_rdbms_status('SDO',9);

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'

Line 17: dbms_registry.invalid('SDO');

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';

Line 24: dbms_registry.invalid('SDO');

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');

Line 28: dbms_registry.valid('SDO');

24: dbms_registry.invalid('SDO');
25: return;
26: end if;
27:
28: dbms_registry.valid('SDO');
29: END;