Jump to content

There is a limit to the parameter input?


Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...