declare
v_clob clob;
v_file bfile;
v_count int;
s_offset int:=1;
d_offset int:=1;
csid int:=0;
lang_ctx number := DBMS_LOB.default_lang_ctx;
warning int;
begin
v_file:=bfilename('CLOBTEMP','1.txt');
v_count:=dbms_lob.getlength(v_file);
dbms_output.put_line(v_count);
select link_str into v_clob from report_link t where t.link_id = '{A158C0D5-6721-4D3B-9EFE-994E61ADA1CC}' for update;
dbms_lob.loadclobfromfile(v_clob,v_file,v_count,s_offset,d_offset,csid,lang_ctx,warning);
dbms_lob.close(v_file);
commit;
end;--- 哪里有问题
v_clob clob;
v_file bfile;
v_count int;
s_offset int:=1;
d_offset int:=1;
csid int:=0;
lang_ctx number := DBMS_LOB.default_lang_ctx;
warning int;
begin
v_file:=bfilename('CLOBTEMP','1.txt');
v_count:=dbms_lob.getlength(v_file);
dbms_output.put_line(v_count);
select link_str into v_clob from report_link t where t.link_id = '{A158C0D5-6721-4D3B-9EFE-994E61ADA1CC}' for update;
dbms_lob.loadclobfromfile(v_clob,v_file,v_count,s_offset,d_offset,csid,lang_ctx,warning);
dbms_lob.close(v_file);
commit;
end;--- 哪里有问题
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货