Unbenannt

CREATE TABLE TBL_LOCATOR_TEST
(
  LNG_ID  NUMBER(7),
  DBL_RW  NUMBER(7),
  DBL_HW  NUMBER(7)
)

CREATE TABLE LOCATOR_TEST
(
  CNT_PARZELLE  NUMBER(7),
  GEOM
)



CREATE OR REPLACE TRIGGER TR_tbl_locator_insert
    AFTER INSERT
        ON tbl_locator_test
        FOR EACH ROW

    BEGIN

    INSERT INTO locator_test
         ( cnt_parzelle,
		   geom.SDO_POINT.X,
		   geom.SDO_POINT.Y
		   
           )
        VALUES
         ( :new.lng_id,
		   :new.dbl_rw,
		   :new.dbl_hw );

    END;