When you DECLARE CURSOR you use a SELECT statement. On that SELECT
statement you specify whether or not you are processing it FOR READ ONLY
or FOR FETCH ONLY. So, the same cursor cannot be used to find the row
(without locking it) and then rereading the row with the lock and then
updating it. WHERE CURRENT OF cannot be specified in a cursor opened FOR
FETCH ONLY (aka FOR READ ONLY).
Rob Berendt
