Re: Sequence Error ORA-02287

Thanks for the reply,

Sorry if this is more of a Java question rather than o.d:

Ok, I'm now putting the currrval into a variable. My query returns a RecordSet, could anyone tell me how to get the value from the RecordSet into a variable.

Whats wrong with this:

RecordSet myResults = DatabaseConnection.ExecuteQuery("SELECT my_seq.currval FROM DUAL");

int currentValue = myResults.getInt("my_seq.currval");

Thanks for any answers,

Jim Received on Mon Mar 21 2005 - 15:40:18 CET