Help! ArcSDE Oracle 11g st_intersects Error!

[kimgeunsoo]

SQL:
select sde.st_asbinary(SHAPE) from scm_mt_tbldg where sde.st_intersects(SHAPE,sde.st_geomfromtext('POLYGON((956613.217824 1918741.991277,956613.217824 1920628.131008,958220.798471 1920628.131008,958220.798471 1918741.991277,956613.217824 1918741.991277))', 2)) = 1;

ERROR:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-01426: numeric overflow
ORA-06512: at "SDE.SPX_UTIL", line 2960
ORA-06512: at "SDE.SPX_UTIL", line 3146
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 291

Help!

[BenLin]

Hi Kim,

Not sure if you have already solved this issue.

Please check this KB article first:
http://support.esri.com/en/knowledgebase/techarticles/detail/35498

You can test the following to swap the ST_INTERSECTS arguments so that the shape argument is on the right and see if you are still encountering the same error.

select sde.st_asbinary(SHAPE) from scm_mt_tbldg where sde.st_intersects(sde.st_geomfromtext('POLYGON((956613.217824 1918741.991277,956613.217824 1920628.131008,958220.798471 1920628.131008,958220.798471 1918741.991277,956613.217824 1918741.991277))', 2),SHAPE) = 1;

And please also confirm your exact ArcSDE version, like 10 SP1 or 10 SP2.

Thanks,
Ben L.