SOLVED: FOR UPDATE is not permitted in this type of statement

[Thomas]

mistake was accessing rte."IDs" which is a view instead of "TBL_IDs" which is
the base table. Also rewrote procedure to use updatable resultset rather
separate select for update and update statement.