There is a limit to the parameter input?


hi! I would like to know if there is any way to limit a parameter of type coleccción which receives 2000 rows. In my query i have: Where
$ X {IN, MEP.MOV_ENT_COBRO_ID, movEntidadCobro}) which the  MEP.MOV_ENT_COBRO_ID table,  contains 2000 rows and is the input parameter for the report.

The error that i get is ORA-01795: maximum number of expressions in a list is 1000, which i  think it happend because the clause in receiving 2000 entries.

lopezanapaula92's picture
Joined: Feb 16 2015 - 4:39pm
Last seen: 1 year 1 month ago

2 Answers:


Not sure on limits related to input parameters, but if you could cut down your input to less than 1000 and see if the ORA error goes away, you'd be able to confirm if the 2000 record input is indeed to large for a parameter. Just a thought, may not be feasible to test.

darth_fader's picture
Joined: Mar 7 2010 - 9:45pm
Last seen: 1 month 2 days ago
hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 year 3 months ago