SQL & PL/SQL

Good Morning,

I need some help on this statement. I don't get to write much pl/sql. I am following the book on how to write it but I keep getting the error above. I have several different tables that needs updating which involves quite a few records.

Using oracle 10g


declare

cursor c1 is

select eval.serial, state_date, current_state, status
from eval, publish_record
where current_state = 'PEND_DEL'
and status = 'PUBLISH'
and eval_id = tr_record_id
and publish_record.type = 'EVAL'
order by state_date
for update;

begin

for c1_rec in c1
loop

update eval set c1_rec.status = 'PUBLISH'
where current of c1_rec;

commit;

end loop;

end;
/


It gives the error on this line

update eval set c1_rec.status = 'PUBLISH'

ORA-06550 line 15
pl/sql: ora-01732: data manipulation operation not legal on this view


This view is not a view but a table in the schema. I don't understand what I am doing wrong.

Any help on this matter is appreciated.

Thanks in advance.

regards,

al