就事论事,下面这段代码可行!
declare
v_ordno varchar2(5);
v_itemcode itemcode;
begin
select item_va into v_itemcode from order_detail where ordno = 'o100';
v_itemcode(4) := 'C0005';
update order_detail set item_va = v_itemcode where ordno = 'o100';
end;
/
declare
v_ordno varchar2(5);
v_itemcode itemcode;
begin
select item_va into v_itemcode from order_detail where ordno = 'o100';
v_itemcode(4) := 'C0005';
update order_detail set item_va = v_itemcode where ordno = 'o100';
end;
/
v_ordno varchar2(5);
删除.不影响结果