Insert WKT Multipolygon (or Multiline)
617918Jan 21 2008 — edited Jan 23 2008Hi @ all,
(using oracle xe (10.2))
I am trying to insert some geometries as a wkt, wih some geometries it works and with some not.
Can anybody tell my why ?
Works with:
-Line
-polygon
Works not with:
- Point
- MultiPoint
- MultiLine
- MultiPolygon
Examples for MultiPolygon:
insert into GEO_MULTIPOLYGON (ID, BEZEICHNUNG, BESCHREIBUNG, GEOM)
values (3, 'INSERT WKT SQLDEVELOPER 3', 'FROM SQLDEV', MDSYS.SDO_GEOMETRY('MULTIPOLYGON (((3330000.0 5440000.0,3550000.0 5440000.0,3550000.0 5550000.0,3330000.0 5550000.0,3330000.0 5440000.0)))', 31467));
commit;
Regards,
Greq