Fetch out of Sequence

Hello

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 8.0.4.0.0 - Production . PL/SQL Release 8.0.4.0.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 .....




Cheers
Afshin

Try setting NONBLOCKSQL=NO

Hi Julian

Thanks I shall get back whether it worked.


Cheerio
Afshin

Quote:

---

Originally posted by afshin
Hi Julian

Thanks I shall get back whether it worked.


Cheerio
Afshin

---

OK, do you know how to set it? Tools, Options, Runtime Settings, and there uncheck Non Blocking SQL.

Hi Julian

I figured that out . Thanks the report works fine now.

Cheers
Afshin