Nested Table question

Hi

Im trying to write a cursor to retrieve all rows from a nested table.
the code i have is:

(the nested table is in a column called acc_inds in the current_installation table.)

CURSOR c_get_acc_inds (
v_cust_id NUMBER
)
IS
SELECT acc.name, acc.value
FROM current_installation ins,
TABLE(ins.acc_inds) acc
WHERE ins.cust_id = v_cust_id;

whilst this works fine as a standalone select is will not work as a cursor (PLS-00201: identifier 'INS.ACC_INDS' must be declared)

how do you write it as a cursor?

Thanks for any help.

Darren. Received on Sat Dec 15 2001 - 13:41:25 CST