ORA-22905: cannot access rows from a non-nested table item
425595Jan 31 2006 — edited Jun 19 2013Hi,
I have a this peace of code:
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;
But when I execute it it returns me the error: ORA-22905: cannot access rows from a non-nested table item.
Can someone tell me how to solve this?
Thank you all in advance.
Best regards,
Carla Almeida