Oracle spatial converts Geometry to gml

In my previous post, I introduced Oracle spatial to convert Geometry to a gml string (http://www.cnblogs.com/likehua/archive/2012/10/18/2730172.html), which mainly uses three functions get_wkt (), sdo_util.TO_GMLGEOMETRY (), and to_char (). In fact, there are no problems with these three functions, just like the test in the previous blog. However, if the Geometry is very large (that is, it has many points), The to_char function will report an error. Because the get_wkt () and to_gmlgeometry () function return results of the clob type, and to_char is converted to the dense type, errors will occur if the data is large. Just like what I encountered today: threw a java. SQL. SQLException: ORA-22835: the buffer is too small for CLOB to CHAR conversion or BLOB to RAW conversion (actual: 24453, Max: 4000 ). To solve this problem, we still use java to honestly convert clob to string type data for openlayers.

Thank you for your comments! Reprint please explain the source: http://www.cnblogs.com/likehua/archive/2012/10/20/2732161.html