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

Last updated on FEBRUARY 11, 2019

Applies to:

Symptoms

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

Cause

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