How to get more than 1000 rec from Oracle?

[vkunirs]

Hi

i got this issue from 1 of my fnd.
can any one tell me how to over come this issue?

I need help in solving the issue

This is the oracle error coming when we try to export
the records to the excel sheet.

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

This error is due to the limitation in oracle db list
query.

example:

select * from FEEDBACK_IN Where feedback_in.case_id
IN ( (param 1) , (param 2) , (param 3) , (param 4) ,
(param 5) , (param 6) , (param 7) , (param 8) , (param
9) , (param 10) , (param 11) , (param 12) , (param
13)?????????.(param 5000))

If the list exceeds 1000, we will get the following
error from the database. And there is a limitation in
oracle db to 1000.

We need to rewrite the query to avoid the list error
if the list exceeds more then 1000 records.

[Dan Bracuk]

You must work with the guy who asked the same question yesterday.
[url]http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?catid=6&threadid=1149324&enterthre ad=y[/url]