Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    3

    Red face Unanswered: ora-01002 "Fetch out of Sequence"

    Hi

    My bd is Oracle 8.1.7.2 and my web Server is Weblogic 5.10 Service pack 9.

    We just recently switched to Service pack 13 and have been getting this ora-01002 "Fetch out of Sequence" error within JAVA code that was running
    fine before the conversion.
    The requests are not request "FOR UPDATE".

    Any ideas???

    Any help would be appreciated! Please contact me at hegmartin@yahoo.fr or or post a reply.

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Kolkata, West Bengal, India
    Posts
    1

    Thumbs up

    This perticular oracle error "Fetch out of Sequence" may occur in 3 cases :-

    1) If The records are trying to be fetched without opening the cursor in your PL/SQL code.

    2) If The records are trying to be fetched after closing the cursor in your PL/SQL code.

    3)If commit is cxecuted within the cursor loop in your

    Check your code now .........

    Arijit
    friend_arijit@yahoo.co.in

  3. #3
    Join Date
    Jan 2003
    Posts
    3

    Red face

    It's not PL/SQL code,

    Here is a part of our code :
    public Vector getListeCommuniques(int numEnt,boolean cor )
    {
    ora=new Oracle(Oracle.PoolSGDCWebmaster);
    Vector vListeCommuniques = new Vector();

    try
    {
    if (debug) System.out.println(this.getClass().getName() +"getListeCommuniques");
    String req ="SELECT ID_COMMUNIQUENET AS ID, SUBSTR(TITRE, 1 ,40) AS TIT, TO_CHAR(DEBUTVALID_DAT, 'DD/MM/YYYY') AS DEB, TO_CHAR(FINVALID_DAT, 'DD/MM/YYYY') AS FIN FROM COMMUNIQUENET ";
    req+= "WHERE ENT_CD=" + numEnt + " AND FK_LANGUESNET =" + IdLangue;
    if (cor)
    {
    req+= " AND FLAG = 1 ORDER BY FINVALID_DAT DESC";
    }
    else
    {
    req+= " AND FLAG = 0 ORDER BY FINVALID_DAT DESC";
    }
    if (debug) System.out.println(this.getClass().getName() +"getListeCommuniques : requête = "+req);
    final String REQUETE=req;
    ora.ouvrirConnexion();
    ora.executerRequete(REQUETE);
    while (ora.rs.next()) {
    Vector vUneListe = new Vector();
    vUneListe.addElement(ora.rs.getString(1));
    String strTitre = ora.rs.getString(2).trim();
    vUneListe.addElement(strTitre);
    vUneListe.addElement(ora.rs.getString(3));
    vUneListe.addElement(ora.rs.getString(4));
    vListeCommuniques.addElement(vUneListe);
    }
    }
    catch(Exception ex) {
    this.sendLog("Exception dans méthode getListeCommuniques :" + ex);
    }
    finally {
    ora.fermerConnexion(this.getClass().getName(),"get ListeCommuniques"); // On ne ferme pas pour pouvoir exploiter le result set à partir des jsp
    return vListeCommuniques;
    }
    }

Posting Permissions

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