Convert XMLType to SDO_GEOMETRY
Is there a way to convert XMLType data to SDO_GEOMETRY?
I saved some data in the XML DB, which includes GML point data. I am now attempting to extract the GML point as an SDO_GEOMETRY.
The extract function returns the XML snippet as an XMLType, using the tag <gml:coord>. When I grab the CLOB value of the XMLType variable, and use it as the input to the SDO_UTIL.FROM_GEMGEOMETRY function, the function complains about the gml:coord not being supported.
Is this something I can do via SQL or PL/SQL? Or is this something I should plan to do via the Java API, because I will need some code to parse one datatype into a format acceptable by the other?
I saved some data in the XML DB, which includes GML point data. I am now attempting to extract the GML point as an SDO_GEOMETRY.
The extract function returns the XML snippet as an XMLType, using the tag <gml:coord>. When I grab the CLOB value of the XMLType variable, and use it as the input to the SDO_UTIL.FROM_GEMGEOMETRY function, the function complains about the gml:coord not being supported.
Is this something I can do via SQL or PL/SQL? Or is this something I should plan to do via the Java API, because I will need some code to parse one datatype into a format acceptable by the other?
0