oracle中对于clob存储xml数据的修改

declare
    v_went_xml clob;
     cursor c_job
     is select t.prp_code,t.went_xml from went_through_prp_xszy t
        left join proposal p on t.prp_code=p.prp_code
        left join proposal_cached pc on p.pos_code=pc.pos_code
        where pc.create_date>to_date('2015-9-30 9:00:00','yyyy-MM-dd HH24:mi:ss') and pc.stat_year='2015' and t.is_check='3';
     c_row c_job%rowtype;
begin
    for c_row in c_job loop
       v_went_xml:=c_row.went_xml;
       Select UPDATEXML(xmlType(v_went_xml), '/data/xssc/ckbischeck','<ckbischeck>4</ckbischeck>').getclobval() into v_went_xml From dual;
       update went_through_prp_xszy t set t.went_xml=v_went_xml where t.prp_code=c_row.prp_code;
    end loop;
end;