Cursor with schema name change

I have two procedures that use a cursor to get data from two tables of same structure, but different accounts:

create or replace procedure test1 as
cursor c1
select firstname from USER1.emp
 where dept = '01';
begin
for l in c1 loop
...

end loop;
end;

create or replace procedure test2 as
cursor c1
select firstname from USER2.emp
 where dept = '01';
begin
for l in c1 loop
...

end loop;
end;  

How can I write one procedure to do the same thing, and pass the schema name(USER1 or USER2) as a variable to call the procedure?

Thank you very much for your help. Received on Mon Sep 15 2003 - 23:03:04 CDT