Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ora-01002 "Fetch out of Sequence"
Is autocommit set ON.If so try taking it off. This may affect code where you
have relied on auto-commit.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Herve MARTIN" <hegmartin_at_yahoo.fr> wrote in message news:f12fe515.0301200432.6547c24f_at_posting.google.com...Received on Mon Jan 20 2003 - 06:51:23 CST
> 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.