Is This Content Helpful?
We're glad to know this article was helpful.
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:
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.
Use a schema name with fewer characters or query the data without a spatial index (which encounters performance issues with large tables because each spatial query results in a full table scan).