oracle 修改 update clob pl/sql,Oracle中的处理CLOB字段的动态PL/SQL存储块

动态PL/SQL,对CLOB字段操作可传递表名table_name，表的唯一标志字段名field_id，clob字段名field_name，记录号v_id，开始处理字符的位置v_pos，传入的字符串变量v_clob

修改CLOB的PL/SQL过程：updateclob

create or replace procedure updateclob(

table_name in varchar2,

field_id in varchar2,

field_name in varchar2,

v_id in number,

v_pos in number,

v_clob in varchar2)

is

lobloc clob;

c_clob varchar2(32767);

amt binary_integer;

pos binary_integer;

query_str varchar2(1000);

begin

pos:=v_pos*32766+1;

amt := length(v_clob);

c_clob:=v_clob;

query_str :='select 'field_name' from 'table_name' where 'field_id'= :id for update ';

--initialize buffer with data to be inserted or updated

EXECUTE IMMEDIATE query_str INTO lobloc USING v_id;

--fro