Trying to write a stored procedure that will work on a table structure without knowing which specific table we are working on. Since we need to scan through a set of the records, i'm trying to build a cursor as

cursor MonthResidential is select * from lcTableName

where lcTableName is a variable holding the table name.

I'm able to use DBMS_SQL to create, populate and index this table, but need to scan through it to perform some calculations and generate an output file.

how can i build this cursor with the information i have?