hi,

If I understand the problem correctly, you could just assign
the database block with the new dname value:

dept.dname := v_dname;

hth.