PL/SQL Error

[Tushar Ravi]

Hello friends,

I am facing an error if I use the tablename from the collection in PL/SQL.

Below is the SQL
SET serveroutput ON; DECLARE type code IS TABLE OF VARCHAR2(100); type pd_code IS TABLE OF VARCHAR2(100); tc code; pc pd_code; uri VARCHAR2(100); BEGIN SELECT DISTINCT code bulk collect INTO tc FROM my_tables my_tables FOR i IN tc.FIRST .. tc.LAST LOOP uri := SUBSTR(tc(i), 5, LENGTH(tc(i))); SELECT DISTINCT uri bulk collect INTO pc FROM tc(i); END LOOP; FOR i IN pc.FIRST .. pc.LAST LOOP DBMS_OUTPUT.PUT_LINE(pc(i)); END LOOP; END;

The error i get : SQL Statement ignored
06550. 00000 - "line %s, column %s:\n%s"

for SELECT DISTINCT uri bulk collect INTO pc FROM tc(i);

Can you please help?

Thanks in Advance
Tushar.