Hi!
I've been desperately trying figure out how to set a table name as an input parameter. Here is the beginning of my code where I declare the table input variable (v_eim_table):

create or replace procedure BATCH_RENUM(k_records_in_batch NUMBER, k_records_to_commit NUMBER, v_batch_num NUMBER, v_eim_table VARCHAR2) is

Here is how I am using this table variable in my cursor variable:

DECLARE
CURSOR batch_cur IS
SELECT ROW_ID,
IF_ROW_BATCH_NUM
FROM v_eim_table
WHERE IF_ROW_BATCH_NUM = v_batch_num
ORDER BY IF_ROW_BATCH_NUM,
ROW_ID;

I get the error that v_eim_table variable must be declared! Please help!
Thanks,
Karen