Error when loading KML data
697015Feb 23 2010 — edited Apr 19 2010Good day!
I'm trying to load KML data from this source http://bbs.keyhole.com/ubb/ubbthreads.php?ubb=showthreaded&Number=521519&site_id=1#import into Oracle 11gR2.
I've loaded the KML into a CLOB column. After that I'm trying to something like this:
insert into temp_geometry
select 1, sdo_util.from_kmlgeometry(clob_content)
from temp_kml_data
I've got a ORA-29532: Java call terminated by uncaught Java exception: java.lang.RuntimeException: Message:KML Geometry type kml not supported.
What can be the reason of this error? What are the exact requirements for the KML data to be loaded? In Spatial manual, I've found only this: "The input geometry must be a valid document conforming to the KML 2.1 specification".