ST_Geometry function is invalid.

anilkumar — Thu, 31 Jan 2019 14:07:59 GMT

Hi,

While running the query on oracle geodatabase, with SQL as sde user, I'm receiving the following Error.

select sde.ST_AsText(SDE.ST_Geometry('POINT(10,10)',0)) from dual;

ERROR:
ORA-20010: Invalid Geometry text dimension. "POINT("
ORA-06512: at "SDE.ST_GEOM_UTIL", line 250
ORA-06512: at "SDE.ST_GEOMETRY", line 20

no rows selected.

I was getting the successful result earlier and no clue about the change happened.

Release 11.2.0.1.0

Any Ideas , on what can cause this problem ?

Regards,

Re: ST_Geometry function is invalid.

JoshuaBixby — Thu, 31 Jan 2019 16:02:24 GMT

The following is invalid WKT:

POINT(10,10)‍

Remove the comma separator.