Query Fails With ORA-00913 - Too Many Values (Doc ID 1396057.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

LARGE Query fails with ORA-00913: too many values
This query has no subqueries. e.g.

select distinct v.paper_id, v.experiment_id, v.loc_id from voxel_tbl v where
( v.x = -29.0 AND v.y = -2.0 AND v.z = -42.0 )
OR ( v.x = -28.0 AND v.y = -2.0 AND v.z = -42.0 )
OR ( v.x = -27.0 AND v.y = -2.0 AND v.z = -42.0 )
OR ( v.x = 28.0 AND v.y = -2.0 AND v.z = -42.0 )
OR ( v.x = 29.0 AND v.y = -2.0 AND v.z = -42.0 )
OR ( v.x = 30.0 AND v.y = -2.0 AND v.z = -42.0 )
OR ( v.x = -30.0 AND v.y = -1.0 AND v.z = -42.0 )
OR ( v.x = -29.0 AND v.y = -1.0 AND v.z = -42.0 )
OR ( v.x = -28.0 AND v.y = -1.0 AND v.z = -42.0 )
OR ( v.x = -27.0 AND v.y = -1.0 AND v.z = -42.0 )
OR ( v.x = -26.0 AND v.y = -1.0 AND v.z = -42.0 )
OR ( v.x = -25.0 AND v.y = -1.0 AND v.z = -42.0 )
OR ( v.x = 26.0 AND v.y = -1.0 AND v.z = -42.0 )
OR ( v.x = 27.0 AND v.y = -1.0 AND v.z = -42.0 )
OR ( v.x = 17.0 AND v.y = 7.0 AND v.z = 47.0 )
OR ( v.x = 18.0 AND v.y = 7.0 AND v.z = 47.0 )
OR ( v.x = 19.0 AND v.y = 7.0 AND v.z = 47.0 )
OR ( v.x = 20.0 AND v.y = 7.0 AND v.z = 47.0 )
OR ( v.x = 21.0 AND v.y = 7.0 AND v.z = 47.0 )
OR ( v.x = -20.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = -19.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = -18.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = -17.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = -16.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = -15.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = -14.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = -13.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = -12.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = -11.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = -10.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = -9.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = -8.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = 10.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = 11.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = 12.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = 13.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = 14.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = 15.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = 16.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = 17.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = 18.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = 19.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = 20.0 AND v.y = 8.0 AND v.z = 47.0 )
OR ( v.x = 21.0 AND v.y = 8.0 AND v.z = 47.0 )
.... too many conditions
order by v.paper_id, v.experiment_id;

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