可以的。例子: create or replace procedure test(v_table in varchar,cu out sys_refcursor) is begin open cu for 'select id from ' || v_table; end;declare v_table varchar2(10):='EMP'; cu sys_refcursor ; emptype emp%rowtype; begin test(v_table,cu); loop fetch cu into emptype; exit when cu%notfound; dbms_output.put_line(emptype.empno); end loop; end;
create or replace procedure test(v_table in varchar,cu out sys_refcursor) is
begin
open cu for 'select id from ' || v_table;
end;declare
v_table varchar2(10):='EMP';
cu sys_refcursor ;
emptype emp%rowtype;
begin
test(v_table,cu);
loop
fetch cu into emptype;
exit when cu%notfound;
dbms_output.put_line(emptype.empno);
end loop;
end;