DBA Data[Home] [Help]

MDSYS.SDO_GEOR_TRIG_UPD1 dependencies on SDO_GEOR_DEF

Line 9: valid:=SDO_GEOR_DEF.isValidEntry(nls_upper(owner),nls_upper(:old.table_name),nls_upper(:old.column_name),nls_upper(:old.rdt_table_name),:old.raster_id);

5: owner VARCHAR2(32);
6: valid VARCHAR2(32);
7: BEGIN
8: owner:=user;
9: valid:=SDO_GEOR_DEF.isValidEntry(nls_upper(owner),nls_upper(:old.table_name),nls_upper(:old.column_name),nls_upper(:old.rdt_table_name),:old.raster_id);
10: if(valid='TRUE')
11: then
12: mderr.raise_md_error('MD', 'SDO', -13391, 'A valid entry cannot be updated directly.');
13: end if;

Line 14: valid:=SDO_GEOR_DEF.isValidEntry(nls_upper(owner),nls_upper(:new.table_name),nls_upper(:new.column_name),nls_upper(:new.rdt_table_name),:new.raster_id);

10: if(valid='TRUE')
11: then
12: mderr.raise_md_error('MD', 'SDO', -13391, 'A valid entry cannot be updated directly.');
13: end if;
14: valid:=SDO_GEOR_DEF.isValidEntry(nls_upper(owner),nls_upper(:new.table_name),nls_upper(:new.column_name),nls_upper(:new.rdt_table_name),:new.raster_id);
15: if(valid='FALSE')
16: then
17: mderr.raise_md_error('MD', 'SDO', -13391, 'The updated entry is not valid.');
18: end if;

Line 21: SDO_GEOR_DEF.deleteMetaEntry(user, :old.rdt_table_name, :old.raster_id);

17: mderr.raise_md_error('MD', 'SDO', -13391, 'The updated entry is not valid.');
18: end if;
19:
20:
21: SDO_GEOR_DEF.deleteMetaEntry(user, :old.rdt_table_name, :old.raster_id);
22:
23:
24: SDO_GEOR_INT.insertUserSysEntry(user, :new.table_name, :new.column_name,
25: :new.metadata_column_name, :new.rdt_table_name, :new.raster_id,