CREATE OR REPLACE PROCEDURE
test_clob (
nRecordID0 in number,
cClob0 in CLOB
)
as
tmp_clob clob;
begin
insert into tbTest(nRecordID ,
cClob)
values(nRecordID0,
empty_clob());
select cClob into tmp_clob from tbTest where nRecordID = nRecordID0 for update;
dbms_lob.append(tmp_clob,cClob0);
end;