ora-01002 "Fetch out of Sequence"

From: Herve MARTIN <hegmartin_at_yahoo.fr>
Date: 20 Jan 2003 04:32:46 -0800
Message-ID: <f12fe515.0301200432.6547c24f@posting.google.com>

Hi

We are using WebLogic 5.1 and Oracle 8.1.7.2.

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_at_yahoo.fr or or post a reply.

It's not a 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(),"getListeCommuniques");

// On ne ferme pas pour pouvoir exploiter le result set à partir des jsp

		return vListeCommuniques;
	}

}

Thanks. Received on Mon Jan 20 2003 - 06:32:46 CST