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 18.104.22.168.0 - Production . PL/SQL Release 22.214.171.124.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 .....