BUG
Schemas in Oracle, approximately 24 characters or greater, which attempt to create a spatial index with st_geometry can result in the following Oracle error:
Code:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 125.
In the sde.st_domain_methods package, the ODCIIndexStart function has a variable string defined as 32 characters, that is not long enough to support schemas names which exceed 24 characters and the name of the spatial index.
Article ID:000010911
Get help from ArcGIS experts
Download the Esri Support App