DECLARE
v_comm integer:=0;
v_name varchar2(255):='供应商';
CURSOR c1 IS
SELECT owner_id FROM owner FOR UPDATE OF owner_name;
BEGIN
FOR r1 IN c1 LOOP
v_comm:=v_comm+1;
v_name:= v_name+v_comm; UPDATE owner
SET owner_name = v_name WHERE CURRENT OF c1;
v_name:='供应商';
END LOOP;
END;
/
代码逻辑很简单,就是对owner 表的owner_name字段进行修改。修改成以“供应商”开头跟上一个整数的标识。但是红色部分会报错,说是不能转换的类型,请问我改怎么做
v_comm integer:=0;
v_name varchar2(255):='供应商';
CURSOR c1 IS
SELECT owner_id FROM owner FOR UPDATE OF owner_name;
BEGIN
FOR r1 IN c1 LOOP
v_comm:=v_comm+1;
v_name:= v_name+v_comm; UPDATE owner
SET owner_name = v_name WHERE CURRENT OF c1;
v_name:='供应商';
END LOOP;
END;
/
代码逻辑很简单,就是对owner 表的owner_name字段进行修改。修改成以“供应商”开头跟上一个整数的标识。但是红色部分会报错,说是不能转换的类型,请问我改怎么做
--------
abc123