Fetch out of Sequence
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Fetch out of Sequence

Hybrid View

  1. #1
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123
    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

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Try setting NONBLOCKSQL=NO

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123
    Hi Julian

    Thanks I shall get back whether it worked.


    Cheerio
    Afshin

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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

  5. #5
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123
    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
  •  


Click Here to Expand Forum to Full Width