Re: Error: ORA-01002

Make sure you have set autocommit to FALSE .. it defaults to true in the Oracle JDBC drivers ... you will get this error if you query 'for update', then commit, and then try to fetch another row from the same cursor.

"Nicolas Bronke" <newsgroup_at_trinity.de> wrote in message news:9852kp$9o5$04$1_at_news.t-online.com...
> When I used the below command where ttt is the table name which have two
> columns(col1,col2):
>
> select * from ttt where col2='India' for update nowait
>
> I am getting an Error: ORA-01002: fetch out of sequence
>
> What could be the reason. I have not having the problem from Oracle.But
 when
> I give the above sql statement in Java(JDBC). Our database is Oracle 8.0.5
>
> Thanks
>
> Nicolas
>
>
>
Received on Wed Mar 07 2001 - 20:01:37 CST