MDSYS.SDO_DROP_USER dependencies on STANDARD

Line 7: if sys.dbms_standard.dictionary_obj_type = 'USER' THEN

3: declare
4: stmt varchar2(200);
5: cnt number;
6: BEGIN
7: if sys.dbms_standard.dictionary_obj_type = 'USER' THEN
8: stmt := 'DELETE FROM SDO_GEOM_METADATA_TABLE ' ||
9: ' WHERE SDO_OWNER = :owner ';
10: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
11:

Line 10: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

6: BEGIN
7: if sys.dbms_standard.dictionary_obj_type = 'USER' THEN
8: stmt := 'DELETE FROM SDO_GEOM_METADATA_TABLE ' ||
9: ' WHERE SDO_OWNER = :owner ';
10: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
11:
12: stmt := 'DELETE FROM SDO_MAPS_TABLE ' ||
13: ' WHERE SDO_OWNER = :owner ';
14: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

Line 14: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

10: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
11:
12: stmt := 'DELETE FROM SDO_MAPS_TABLE ' ||
13: ' WHERE SDO_OWNER = :owner ';
14: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
15:
16: stmt := 'DELETE FROM SDO_CACHED_MAPS_TABLE ' ||
17: ' WHERE SDO_OWNER = :owner ';
18: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

Line 18: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

14: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
15:
16: stmt := 'DELETE FROM SDO_CACHED_MAPS_TABLE ' ||
17: ' WHERE SDO_OWNER = :owner ';
18: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
19:
20: stmt := 'DELETE FROM SDO_STYLES_TABLE ' ||
21: ' WHERE SDO_OWNER = :owner ';
22: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

Line 22: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

18: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
19:
20: stmt := 'DELETE FROM SDO_STYLES_TABLE ' ||
21: ' WHERE SDO_OWNER = :owner ';
22: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
23:
24: stmt := 'DELETE FROM SDO_THEMES_TABLE ' ||
25: ' WHERE SDO_OWNER = :owner ';
26: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

Line 26: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

22: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
23:
24: stmt := 'DELETE FROM SDO_THEMES_TABLE ' ||
25: ' WHERE SDO_OWNER = :owner ';
26: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
27:
28: stmt := 'DELETE FROM SDO_LRS_METADATA_TABLE ' ||
29: ' WHERE SDO_OWNER = :owner ';
30: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

Line 30: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

26: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
27:
28: stmt := 'DELETE FROM SDO_LRS_METADATA_TABLE ' ||
29: ' WHERE SDO_OWNER = :owner ';
30: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
31:
32: stmt := 'DELETE FROM SDO_TOPO_METADATA_TABLE ' ||
33: ' WHERE SDO_OWNER = :owner ';
34: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

Line 34: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

30: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
31:
32: stmt := 'DELETE FROM SDO_TOPO_METADATA_TABLE ' ||
33: ' WHERE SDO_OWNER = :owner ';
34: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
35:
36: stmt := 'DELETE FROM SDO_ANNOTATION_TEXT_METADATA ' ||
37: ' WHERE F_TABLE_SCHEMA = :owner ';
38: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

Line 38: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;

34: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
35:
36: stmt := 'DELETE FROM SDO_ANNOTATION_TEXT_METADATA ' ||
37: ' WHERE F_TABLE_SCHEMA = :owner ';
38: EXECUTE IMMEDIATE stmt USING sys.dbms_standard.dictionary_obj_name;
39: end if;
40: end;