I have received the following error ORA-01002 fetch of sequence quite a few times while generating reports.
The Clients which have been developed in Reports 2.5
the DB Version is Oracle8 Enterprise Edition Release 126.96.36.199.0 - Production . PL/SQL Release 188.8.131.52.0 - Production .
The error is not often though and can be solved while re-writing the query or removing the order by which is not possible always .
The query runs fine from SQL though .....