Error generating shape from text: Invalid text used to construct geometry (-1)

错误信息:
SQL> select SDE.ST_GEOMETRY (‘POLYGON ((503433.822 294306.924, 503514.177 294339.956, 503531.789 294297.311, 503524.894 294272.889, 503481.474 294257. 951, 503450.539 294265.595, 503433.794 294306.914))’,2436) from dual;
ERROR at line 1: ORA-20004: Error generating shape from text: Invalid text used to construct geometry (-1).
Text: POLYGON ((503433.822 294306.924, 503514.177 294339.956, 503531.789 294297.311, 503524.894 294272.889, 503481.474 294257. 951, 503450.539 294265.595, 503433.794 294306.914)) ORA-06512: at “SDE.ST_GEOMETRY_SHAPELIB_PKG”, line 12 ORA-06512: at “SDE.ST_GEOMETRY”, line 55
原因:
ArcSDE空间SQL要求Polygon点串坐标的第一个点的X，Y坐标需要和最后一个点的X，Y坐标的坐标需要一致。
解决方法:
select SDE.ST_GEOMETRY (‘POLYGON ((503433.822 294306.924, 503514.177 294339.956, 503531.789 294297.311, 503524.894294272.889, 503481.474 294257.951, 503450.539 294265.595, 503433.794 294306.914, 503433.822294306.924))’,2436) from dual; 6.924))’,2436) from dual;
文章来源：http://blog.csdn.net/liufeng1980423/article/details/48969575