ST_Geometry function is invalid.

1345
1
Jump to solution
01-31-2019 06:07 AM
anilkumar
New Contributor II

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,

0 Kudos
1 Solution

Accepted Solutions
JoshuaBixby
MVP Esteemed Contributor

The following is invalid WKT:

POINT(10,10)

Remove the comma separator.

View solution in original post

1 Reply
JoshuaBixby
MVP Esteemed Contributor

The following is invalid WKT:

POINT(10,10)

Remove the comma separator.