Menu
I am passing a list of Strings to my query(SQL query written) to fetch the required data. But I am getting this exception:
ora-01795 maximum number of expressions in a list is 1000
I checked that I have more than 1000 entries in the list passed to the query IN parameter.
755
This ORA-01795 errors are related with More than 254 columns or expressions were specified in a list. You should remove some of the expressions from the list. To solve this error, Use the “UNION” clause to join together two separate queries and make it appear like a single result table.
ORA-01795: maximum number of expressions in a list is 1000 Error When Associating more than 1000 Inventory Groups to an Entity.
To query more than 1000 rows, there are two ways to go about this. Use the '$offset=' parameter by setting it to 1000 increments which will allow you to page through the entire dataset 1000 rows at a time. Another way is to use the '$limit=' parameter which will set a limit on how much you query from a dataset.
this is a oracle limitation in the number of list pass in the query.
68
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
