假设有一个表ssk，这个表有clob字段。

create or replace procedure insertclob

(newid number,text varchar2)

as

clob_loc clob;

amount int;

offset int;

begin

select resume into clob_loc from ssk where id=newid for update;

offset:=dbms_lob.getlength(clob_loc)+1;

amount:=length(text);

dbms_lob.write(clob_loc,amount,offset,text);

commit;

end;

/