ORA-24801 illegal parameter value in OCI lob functionCause: One of the parameter values in the OCI LOB function is illegal.Action: Check every parameter in the OCI Lob function call to make sure they are correct. Offsets should be greater than or equal to one.
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;VC++ 连续调用第二次的时候报ORA-24801
correct. Offsets should be greater than or equal to one.
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;VC++ 连续调用第二次的时候报ORA-24801