wood burning stoves 2.0*
The moose likes JDBC and the fly likes ora-01002 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ora-01002 "Fetch out of Sequence"" Watch "ora-01002 "Fetch out of Sequence"" New topic
Author

ora-01002 "Fetch out of Sequence"

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
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@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.
pino astarita
Greenhorn

Joined: Nov 14, 2006
Posts: 15
Hi,

I've the same problem's but actually i don't have resolved it, if you have can say me in which way ? Thank's a lot

Giuseppe
Carol Enderlin
drifter
Ranch Hand

Joined: Oct 10, 2000
Posts: 1364
If you are using WebLogic 5.1 and Oracle 8.1.7.2 like the original poster from over three years ago, I am so sorry.

There is rarely a point to resurrecting such old posts (seeDontWakeTheZombies).

You should really start your own post and tell us the details.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ora-01002 "Fetch out of Sequence"
 
Similar Threads
SQLException Cursor Closed
Invalid Oracle URL specified
query to get 3 record of latest dates
Select date field problem
ora-01002 fetch out of sequence