17,086
社区成员
发帖
与我相关
我的任务
分享
DECLARE
number_table_tmp NUM_ARRAY:=NUM_ARRAY(410673, 414303, 414454, 413977, 414042, 414115, 413972, 414104, 414062);
BEGIN
FOR c1 IN (SELECT par_id, 1 acc_vdo_id FROM SIG_VIS_CAM
WHERE par_id IN (SELECT * FROM TABLE(number_table_tmp))
UNION ALL
SELECT par_id, 2 acc_vdo_id FROM SIG_ACCAO a
WHERE par_id IN (SELECT * FROM TABLE(number_table_tmp))) LOOP
NULL;
END LOOP;
END;
error: ORA-22905: cannot access rows from a non-nested table item
WHERE par_id IN (SELECT * FROM TABLE(number_table_tmp))
改成
WHERE par_id IN (SELECT id FROM <your table>)