CREATE OR REPLACE procedure SFCWEB.DELETE_s_cop_tnid_t
as
begin
EXECUTE IMMEDIATE 'DROP SEQUENCE SFCWEB.S_TN_ID;';
end;
CREATE OR REPLACE procedure SFCWEB.DELETE_s_cop_tnid_t
as
begin
EXECUTE IMMEDIATE ' CREATE SEQUENCE SFCWEB.S_TN_ID
START WITH 0
MAXVALUE 99
MINVALUE 0
NOCYCLE
NOCACHE
NOORDER;';
end;
然后用JOB 控制， 这样应该可以实现的
但是我执行这两个存储过程的时候且报如下错误
ORA-06550: line 1, column 31:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
;
The symbol ";" was substituted for "end-of-file" to continue.
大家有什么好方法吗？
