写了job定时跑个存储过程 为的是初始化序列
但是 存储过程 老是失败? 各位帮忙看看create or replace procedure declear as
begin
execute immediate '
drop sequence COM_FEEDBACK_SEQ';
execute immediate 'create sequence COM_FEEDBACK_SEQ
minvalue 1
maxvalue 1000000
start with 1
increment by 1
cache 20 ';
end;
但是 存储过程 老是失败? 各位帮忙看看create or replace procedure declear as
begin
execute immediate '
drop sequence COM_FEEDBACK_SEQ';
execute immediate 'create sequence COM_FEEDBACK_SEQ
minvalue 1
maxvalue 1000000
start with 1
increment by 1
cache 20 ';
end;
create or replace procedure xxx
as
begin
execute immediate '
drop sequence COM_FEEDBACK_SEQ';
execute immediate 'create sequence COM_FEEDBACK_SEQ
minvalue 1
maxvalue 1000000
start with 1
increment by 1
cache 20 ';
end;