Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Run-time error using SDO_GEOMETRY constructor with WKT

jonathan.listerMay 27 2008 — edited Jun 21 2010

Are there limitations when using the WKT in constructor of SDO_GEOMETRY?

select SDO_GEOMETRY('MULTIPOINT (7.627958 50.883906, 7.827958 52.883906)') from dual
results in:
Error code 29532, SQL state 99999: ORA-29532: Java call terminated by uncaught Java exception: java.lang.RuntimeException
ORA-06512: at "MDSYS.SDO_UTIL", line 137
ORA-06512: at "MDSYS.SDO_GEOMETRY", line 76

same result for POLYGON, however, the simpler
SELECT SDO_GEOMETRY('POINT(-79 37)') FROM DUAL;
is OK.

Are multiPoints, Polygons etc. supported from WKT?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2010

Added on May 27 2008

#database-key-features, #spatial

13 comments

6,475 views