We are having a problem trying to lock a record for update in Oracle 8.

The SQL read somenthing like

select * from category where category='ACC' for update

Delphi does not returns anything and the SQL monitor shows the following
Oracle Error

ORA-01002: fetch out of sequence