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 10.2.0.4.0 to 11.2.0.4
Information in this document applies to any platform.

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

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 hundreds of Community platforms