UPDATE/DELETE WHERE CURRENT OF

Informix® allows positioned UPDATEs and DELETEs with the "WHERE CURRENT OF cursor" clause, if the cursor has been DECLARED with a SELECT ... FOR UPDATE statement.

UPDATE/DELETE ... WHERE CURRENT OF<cursor> is not support by the Oracle database API. However, ROWIDs can be used for positioned updates/deletes.

Solution

UPDATE/DELETE ... WHERE CURRENT OF instructions are managed by the ORACLE database interface. The ORACLE database interface replaces "WHERE CURRENT OF cursor" by "WHERE ROWID=:rid" and sets the value of the ROWID returned by the last FETCH done with the given cursor.