CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Overcome SQL IN clause limit

Hello!

We have some reports to show subscription data and optionally we would like to filter by customer account.

We can add a parameter in the Data Model with a list of values to do this filter, but if we use an IN clause, we will reach the limit of 1000 values and the report will break.

I saw alternatives on the internet with temporary tables or a select clause with the list (for example, SELECT * FROM TABLE(SYS.ODCIVARCHAR2LIST(:CUSTOMER_LIST)), but I couldn't make it work using the parameter. In the case of the example above, due to the same limitation of 1000 values.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center