Hello All

Is it possible to use a Parameter passed to a procedure as the table name
in a cursor selection statment. I thought the below would work but I get
a error. Does anyone have any ideas??

CREATE OR REPLACE PROCEDURE TEST(TABLENAME IN VARCHAR2) IS

CURSOR c1 IS SELECT MUNI FROM TABLENAME GROUP BY CITY;

c1rec c1%ROWTYPE;

BEGIN
OPEN c1;
LOOP
FETCH c1 INTO c1rec;
EXIT WHEN c1%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(c1rec.CITY);
END LOOP;
CLOSE c1;
END;

Thanks

Peter