Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Bucharest - Romania
    Posts
    2

    Unanswered: ORA-01002: fetch out of sequence

    I have 2 systems: an OpenVMS v6.2 with an Oracle 7.1.5 database and a HP-UX 11i with an Oracle 9i database. I can access the Oracle 9i tables from the Oracle 7 SQLPlus, via a database link, but when I tried to access the Oracle7 tables from the Oracle 9i SQLPlus in a similar way, I get only the error "ORA-01002: fetch out of sequence". Any ideas to help me ??? Thank you very much !

  2. #2
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311

    Re: ORA-01002: fetch out of sequence

    Hi,

    Probably, you're using a 9.2 database to access the version 7 tables. According to Oracle 9i does not support accessing oracle 7 tables. The latest release supported is 9.1.
    Edwin van Hattem
    OCP DBA / System analyst

  3. #3
    Join Date
    Sep 2003
    Location
    Bucharest - Romania
    Posts
    2

    Thank you for Re: ORA-01002: fetch out of sequence

    It's true. I have Oracle 9.2 and I tried to access an Oracle7 database.
    Thank you very much !
    Best regards,
    Mirela Tataroiu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •