Bug Number NIM063576
Submitted Dec 14, 2010
Modified Jan 18, 2021
Severity High
Applies To ArcGIS for Desktop
Version Found 10.0
Prog Language N/A
Server Platform Windows XP
Client Platform Windows XP
Database Oracle
Locale N/A
Status Implemented
Version Fixed N/A
SP Fixed 10.0SP5

Bug NIM063576


Getting “ORA-21500” error code when using Query Layer to query a ST_Geometry table created by the ‘sde.st_pointfromtext’ function.

Additional Information


Alternate Solution

Use the text constructor for ‘ST_Geometry (column data type) with identical WKT, ex:insert into t6 values (11, sde.st_geometry('point (-112 41)',3));’ instead of using the constructor for the ‘ST_POINTFROMTEXT sub-type, ex:insert into t3 values (11, sde.st_pointfromtext('point (-112 41)',3));’.