Hi,

I am getting "ORA-01002: fetch out of sequence" error while updating a column in a table using update query in JDBC adapter as below.

The below query update a row in plsql but getting error with jdbc adapter.

This GET function passed in side a function map to update the count column for each id.so for each iteration it supposed to update the column in the table.

is it possible in this way or i need to follow traditional way of creating a type tree of the table with DB adapter with -UPDATE only parameter.

GET("JDBC","-URL <url> -USER <userid> -PASSWORD <pwd> -T -AS 0 -QTY * -LSN 0 -QUERY ""update <tablename> set count='"+Count+"' where id= '" +id+"' and id1='"+id1+"' ")

Error from Trace file

Caused by: Error : 1002, Position : 0, Sql = update <tablename> set count='1' where id= '11' and id1='111', OriginalSql = update <tablename> set count='1' where id= '11' and id1='111', Error Msg = ORA-01002: fetch out of sequence

Thanks

Santanu