When I run a report , it gives an error as
ORA-01002:fetch out of sequence problem.
The report contains only couple of queries with parameters. When I run the same report in different env, it works fine. But in production env, it displays with the above error message. The report works fine If i run for individual item but if I give % to run for all items. Then It displays an error message.
I asked my DBA to check the Rollaback segment, he says it is ok. I am still not able to understand, what might be the problem. Can somebody help me on this problem. I am using Oralce report 2.5. One query has some four joins.