如何在光标中传递表名作为参数？

Question

我有一个光标查询外部表的过程。我如何通过select的表名？

procedure ImpInsData(fileN varchar2,Tname VARCHAR2) 
as 
begin 
    IXRBI.EXternalChange (fileN,Tname);  
    declare 
     cursor cur_extenal is select * from Tname WHERE A IN ('1','2'); 
    begin 
     FOR rec IN cur_extenal LOOP 
     vId :=sys_guid(); 
     vRowStatus:=rec.A; 
     vTag:=rec.C; 
     end loop 
    end; 
end; 

Tname是指定表名称的参数。

我该如何重写它？

Answer 1

procedure ImpInsData(fileN varchar2) 
as 
CURSOR cur_extenal IS 
(
select * from Tname WHERE A IN ('1','2') 
); 
begin 
open cur_extenal 

FETCH cur_extenal into rec 
     FOR rec IN cur_extenal LOOP 
     vId :=sys_guid(); 
     vRowStatus:=rec.A; 
     vTag:=rec.C; 
exit when cur_extenal%notfound; 
     end loop; 
close cur_extenal; 
    end;