Im trying to retreive a report with more than 3000 values in the the value prompt and its thrown with an err: ORA 01795 "maximum number of experssion in a list is 1000" and i could see a limit of 1000 for IN operator in oracle.Please let me know any ideas of overcoming this
Thanks,
Murali
The only idea that come to my mind is to do union with different queries that have a max on 1000 elements.
Don't know if it could work inside report studio..