SQL> desc core_vow_geo_sale
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PROPERTY_ID                               NOT NULL NUMBER
 ADDRESS_GEOMETRY                                   MDSYS.SDO_GEOMETRY

PROCEDURE iCVPGeoSale(isrc  IN number)
IS
BEGIN
    INSERT INTO core_vow_geo_sale@sagwadb
    (property_id, address_geometry)
    SELECT property_id, address_geometry
      FROM core_vow_geo_sale A,
           core_vow_prop_status b
     WHERE property_id = b.prop_id
       AND b.prop_source = isrc
       AND b.prop_update = 2;
EXCEPTION
WHEN OTHERS THEN
    RAISE;
END;