表test
test_id varchar2类型
test_vaule clob类型create or replace procedure updateclob(
v_clob in varchar2,
res out varchar2)
is
begin
update test set test_value = v_clob where test_id = '1';
commit;
exception
when others then
rollback;
end updateclob;当入参v_clob内容过多时(超过4000字节) 会报str绑定值的结尾Null字符缺失。
望大虾们指教!!
test_id varchar2类型
test_vaule clob类型create or replace procedure updateclob(
v_clob in varchar2,
res out varchar2)
is
begin
update test set test_value = v_clob where test_id = '1';
commit;
exception
when others then
rollback;
end updateclob;当入参v_clob内容过多时(超过4000字节) 会报str绑定值的结尾Null字符缺失。
望大虾们指教!!
v_clob in clob,
res out varchar2)
is
begin
update test set test_value = v_clob where test_id = '1';
commit;
exception
when others then
rollback;
end updateclob;