There is a limit to the parameter input?

[lopezanapaula92]

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.

[darth_fader]

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.

[hozawa]

Seems to be the same question asked in the following posts.

http://stackoverflow.com/questions/20344821/jasperreports-how-to-put-more-than-1000-values-in-a-list-into-x-statement

https://stackoverflow.com/questions/31484576/is-there-a-maximum-length-for-jasper-parameter-lists