declare
type t_sor is ref curosr;
v_sor t_sor;
str varchar2(100);
begin
str:='select fee1';
for i in 2..20 loop
str:=str||' ,fee'||i;
end loop;
str:=str||' from table';
open v_sor for str;
.....
end;
/
type t_sor is ref curosr;
v_sor t_sor;
str varchar2(100);
begin
str:='select fee1';
for i in 2..20 loop
str:=str||' ,fee'||i;
end loop;
str:=str||' from table';
open v_sor for str;
.....
end;
/
ERROR 位于第 1 行:
ORA-00904: invalid column name
ORA-06512: at line 11