Select * from gtable where col1 > 93 order by col1 for update of col2 .
update gtable set col2= col2 * -1 where current of testcursor.
when executing the update query i got the error of sqlcode = -510, error: the table designated by the cursor of the update or delete statement cannot be modified .
is it possible to update the current row pointed by the cursor for the select query with order by and for update of clause?

yes we can do