MDSYS.SDO_TOPO_DROP_FTBL dependencies on DBMS_STANDARD

Line 10: if(sys.dbms_standard.dictionary_obj_type != 'TABLE')

6: topology VARCHAR(100);
7: REG_TBL EXCEPTION;
8:
9: BEGIN
10: if(sys.dbms_standard.dictionary_obj_type != 'TABLE')
11: then
12: return;
13: end if;
14: stmt := 'SELECT topology ' ||

Line 18: USING sys.dbms_standard.DICTIONARY_OBJ_OWNER,

14: stmt := 'SELECT topology ' ||
15: 'FROM MDSYS.SDO_TOPO_METADATA_TABLE a, TABLE(a.Topo_Geometry_Layers) b ' ||
16: 'WHERE b.owner = :owner AND b.table_name = :tab ';
17: EXECUTE IMMEDIATE stmt into topology
18: USING sys.dbms_standard.DICTIONARY_OBJ_OWNER,
19: sys.dbms_standard.DICTIONARY_OBJ_NAME;
20: RAISE REG_TBL;
21:
22: EXCEPTION

Line 19: sys.dbms_standard.DICTIONARY_OBJ_NAME;

15: 'FROM MDSYS.SDO_TOPO_METADATA_TABLE a, TABLE(a.Topo_Geometry_Layers) b ' ||
16: 'WHERE b.owner = :owner AND b.table_name = :tab ';
17: EXECUTE IMMEDIATE stmt into topology
18: USING sys.dbms_standard.DICTIONARY_OBJ_OWNER,
19: sys.dbms_standard.DICTIONARY_OBJ_NAME;
20: RAISE REG_TBL;
21:
22: EXCEPTION
23: WHEN REG_TBL THEN

Line 27: || sys.dbms_standard.DICTIONARY_OBJ_NAME ||

23: WHEN REG_TBL THEN
24: MDSYS.MDERR.raise_md_error(
25: 'MD', 'SDO', -13199,
26: 'Need to use delete_topo_geometry_layer() to deregister table '
27: || sys.dbms_standard.DICTIONARY_OBJ_NAME ||
28: ' from topology ' || topology ||
29: ' before dropping it');
30: WHEN OTHERS THEN
31: RETURN;