PL/SQL cursor : from VARIABLE

hi all

in PL/SQL, i want to declare a cursor
where the table name is a variable like

cursor rec (table_name in varchar2) is
  select *
  from table_name;

but it doesn't work
thank you for your help
FRED Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 14 1999 - 04:40:07 CST