CREATE OR REPLACE PROCEDURE PROC_INSERT_COPER_INFO(
v_COO_ORG IN VARCHAR2,
v_PROD_TASK_INFO_ID IN VARCHAR2,
v_COPER_TYPE IN VARCHAR2
)
AS
CURSOR C_COPER_ORG IS SELECT * FROM TABLE(CAST(SPLIT_FOR_ARRAY(v_COO_ORG, ',') AS ARRAY_CONTAINER));
v_ORG C_COPER_ORG%rowtype;
BEGIN
--先删除在增
delete from COPER_INFO where EMER_TASK_ID = v_PROD_TASK_INFO_ID and COPER_TYPE=v_COPER_TYPE;
--循环迭代
for v_ORG in C_COPER_ORG loop
dbms_output.put_line('---------,v_ORG.Column_Value-----------== ' || v_ORG.Column_Value);
insert into COPER_INFO(COPER_INFO_ID,EMER_TASK_ID,COPER_ORG,COPER_TYPE,COPER_STATE)
values (SEQ_COPER_INFO.NEXTVAL,v_PROD_TASK_INFO_ID,v_ORG.Column_Value,v_COPER_TYPE,'001');
end loop;
END;
v_COO_ORG IN VARCHAR2,
v_PROD_TASK_INFO_ID IN VARCHAR2,
v_COPER_TYPE IN VARCHAR2
)
AS
CURSOR C_COPER_ORG IS SELECT * FROM TABLE(CAST(SPLIT_FOR_ARRAY(v_COO_ORG, ',') AS ARRAY_CONTAINER));
v_ORG C_COPER_ORG%rowtype;
BEGIN
--先删除在增
delete from COPER_INFO where EMER_TASK_ID = v_PROD_TASK_INFO_ID and COPER_TYPE=v_COPER_TYPE;
--循环迭代
for v_ORG in C_COPER_ORG loop
dbms_output.put_line('---------,v_ORG.Column_Value-----------== ' || v_ORG.Column_Value);
insert into COPER_INFO(COPER_INFO_ID,EMER_TASK_ID,COPER_ORG,COPER_TYPE,COPER_STATE)
values (SEQ_COPER_INFO.NEXTVAL,v_PROD_TASK_INFO_ID,v_ORG.Column_Value,v_COPER_TYPE,'001');
end loop;
END;