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


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