Error, "ORA-01795: maximum number of expressions in a list is 1000" when running a query with mor (4232200)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error, "ORA-01795: maximum number of expressions in a list is 1000" when running a query with mor
Description

When running a query that contains more than 1000 conditions in the IN clause the following error occurs:

ORA-01795: maximum number of expressions in a list is 1000
Cause

Oracle limitation: Cannot have more than 1000 literals in an IN clause.
Resolution

Workaround:

None. Oracle limitation and not Quest application related.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title