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.
There is a limit to the parameter input?
in Products
Posted
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.