Well, I figured out the (HUGE CLOB) issue, but I still can't get it to convert from UTM to Latitude, Longitude. I get an error saying
ORA-20603: Spatial References are not compatible. ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 788 ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 2577 |
Here's the SQL
SELECT EID, SHAPE, ST_X(SHAPE) as X, ST_Y(SHAPE) as Y,
sde.st_astext(sde.st_transform(SHAPE, 0)) AS TEXTCOORD
FROM LIS.ADDRESS_PNT
I was just testing the ST_X and ST_Y to see if any ST_Geometry operations would work (and they did).