DBA Data[Home] [Help]

MDSYS.SDO_CRS_INSERT_TRIGGER dependencies on SDO_CS

Line 11: MDSYS.sdo_cs.sdo_cs_context_invalidate;

7: FOR EACH ROW
8: DECLARE
9: already_exists NUMBER;
10: BEGIN
11: MDSYS.sdo_cs.sdo_cs_context_invalidate;
12:
13: INSERT INTO MDSYS.SDO_COORD_REF_SYS (
14: SRID,
15: COORD_REF_SYS_NAME,

Line 52: INSERT INTO MDSYS.SDO_CS_SRS (

48: :new.LEGACY_CS_BOUNDS,
49: :new.IS_VALID,
50: :new.SUPPORTS_SDO_GEOMETRY);
51:
52: INSERT INTO MDSYS.SDO_CS_SRS (
53: CS_NAME,
54: SRID,
55: AUTH_SRID,
56: AUTH_NAME,

Line 68: MDSYS.sdo_cs.internal_det_srid_wkt(:new.srid)),

64: :new.SRID,
65: :new.INFORMATION_SOURCE,
66: NVL(
67: :new.LEGACY_WKTEXT,
68: MDSYS.sdo_cs.internal_det_srid_wkt(:new.srid)),
69: sdo_cs.get_3d_wkt(:new.srid),
70: :new.LEGACY_CS_BOUNDS);
71:
72: if(:new.COORD_REF_SYS_KIND = 'GEOGRAPHIC3D') then

Line 69: sdo_cs.get_3d_wkt(:new.srid),

65: :new.INFORMATION_SOURCE,
66: NVL(
67: :new.LEGACY_WKTEXT,
68: MDSYS.sdo_cs.internal_det_srid_wkt(:new.srid)),
69: sdo_cs.get_3d_wkt(:new.srid),
70: :new.LEGACY_CS_BOUNDS);
71:
72: if(:new.COORD_REF_SYS_KIND = 'GEOGRAPHIC3D') then
73: insert into sdo_crs_geographic_plus_height values (:new.srid);