我写的存储过程如下：
create or replace procedure project_temp as
v_exe_sql varchar2(200);
vnumber number;
gnum number;
begin
begin
gnum :=0;
vnumber :=1;
for vnumber in 1..50 loop
gnum := gnum+1;
begin
v_exe_sql:='alter table temp_ras_project add 偿'||gnum||'number';
execute immediate v_exe_sql;
end;
end loop;
end;
end project_temp;
这个存储过程的用途是为表temp_ras_project增加50个字段不知道存储过程能不能实现，编译没有错误，但是执行就报错了。
请高手给予指点。
------解决方案--------------------
create or replace procedure project_temp as
v_exe_sql varchar2(200);
vnumber number;
gnum number;
begin
begin
gnum :=0;
vnumber :=1;
for vnumber in 1..50 loop
gnum := gnum+1;
begin
v_exe_sql:='alter table temp_ras_project add 偿'||gnum||' number';
execute immediate v_exe_sql;
end;
end loop;
end;
end project_temp;
加个空格
------解决方案--------------------
- SQL code
create or replace procedure project_temp as v_exe_sql varchar2(200); vnumber number; gnum number; begin begin gnum :=0; vnumber :=1; for vnumber in 1..50 loop gnum := gnum+1; begin v_exe_sql:='alter table temp_ras_project add 偿'[color=#FF0000]||gnum||' number'[/color]; execute immediate v_exe_sql; end; end loop; end;end project_temp;