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.