-
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
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Hi Julian
Thanks I shall get back whether it worked.
Cheerio
Afshin
-
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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Hi Julian
I figured that out . Thanks the report works fine now.
Cheers
Afshin
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|