| 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
Synopsis
Getting “ORA-21500” error code when using Query Layer to query a ST_Geometry table created by the ‘sde.st_pointfromtext’ function.
Additional Information
N/A
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));’.