My Oracle Support Banner

SDO_AGGR_LRS_CONCAT Fails with "ORA-22813 - operand value exceeds system limits" error (Doc ID 1101283.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version to
Information in this document applies to any platform.


Getting error -

SQL> SELECT sdo_aggr_lrs_concat (sdoaggrtype(v.geom,0.5)) geom
         FROM (SELECT /*+ NO_MERGE */ s.geom
                FROM  xtest_lrs_concat_shapes s
               WHERE  s.road_id = 476
               ORDER BY s.segment_id) v;  
SELECT sdo_aggr_lrs_concat (sdoaggrtype(v.geom,0.5)) geom
ERROR at line 1:
ORA-22813: operand value exceeds system limits


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.