在Procedure中调用Sequences,需加上单引号
如:
create or replace procedure proc3
as
begin
for i in 1 .. 10000
loop
execute immediate
'insert into t values(' || 'SEQ_TEST.NEXTVAL' || ')';
end loop;
end;
在Procedure中调用Sequences,需加上单引号
如:
create or replace procedure proc3
as
begin
for i in 1 .. 10000
loop
execute immediate
'insert into t values(' || 'SEQ_TEST.NEXTVAL' || ')';
end loop;
end;