APEX ORACLE PROCEDURE LOOP WITH apex_string.split

Question

我正在使用Oracle APEX 22.1.0。

在我的过程中使用循环apex_string.split

和数据像(data1,data2,data3,data4)到P_EMPIDS

我想循环每个数据行与更新表

LOOP      
select column_value INTO L_EMPIDS
from table(apex_string.split(P_EMPIDS, ','));
UPDATE NB_ASSET_CODE SET OWNER_ID = P_ASSET_2 WHERE COMPANY_ID = L_COMPANY_ID AND 
ASSET_CODE = L_EMPIDS;
END LOOP;

如何循环?这个循环不起作用

Answer 1

假设您知道p_asset_2和l_company_id是什么，那么

DECLARE
p_asset_2 ...
l_company_id ...
BEGIN
FOR cur_r
IN (SELECT COLUMN_VALUE as l_empids
FROM TABLE (apex_string.split (p_empids, ',')))
LOOP
UPDATE nb_asset_code
SET owner_id = p_asset_2
WHERE     company_id = l_company_id
AND asset_code = cur_r.l_empids;
END LOOP;
END;