Query Fails With ORA00913  Too Many Values
Last updated on DECEMBER 06, 2016
Applies to:
Oracle Database  Enterprise Edition  Version 11.2.0.3 and laterInformation in this document applies to any platform.
Symptoms
LARGE Query fails with ORA00913: 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;
( 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