ORACLE储存过程合并数组

基于BULK COLLECT INTO会覆盖原数组内容,则 数组A:=数组A  MULTISET UNION  数组B

I_ID_ARRAY ID_ARRAY:=ID_ARRAY();

I_ID_ARRAY2 ID_ARRAY:=ID_ARRAY();
begin
  SELECT ROLE_ID BULK COLLECT INTO I_ID_ARRAY FROM t_eap_sys_role_user;
select ROLE_ID BULK COLLECT INTO I_ID_ARRAY2 from t_eap_sys_role;
  I_ID_ARRAY:=I_ID_ARRAY MULTISET UNION I_ID_ARRAY2;
  O_RESULT:=I_ID_ARRAY.COUNT;
  RETURN;
end P_CM_POWER_OF_PART;

begin
  SELECT ID BULK COLLECT INTO I_ID_ARRAY FROM #tablename#;
select ID BULK COLLECT INTO I_ID_ARRAY2 from #tablename#;
  I_ID_ARRAY:=I_ID_ARRAY MULTISET UNION I_ID_ARRAY2;