我想每天自动执行以下SQL,目的就是每天从1开始递增
begin
EXECUTE IMMEDIATE 'DROP SEQUENCE SEQ_QCNO';
EXECUTE IMMEDIATE 'CREATE SEQUENCE SEQ_QCNO START WITH 1 MAXVALUE 999 MINVALUE 1 CYCLE NOCACHE NOORDER';
end;直接在toad中执行这段是没有问题的,可一但设到job中,第二句总是不执行,不知问题出在哪里?
望高手指点迷津,谢谢
begin
EXECUTE IMMEDIATE 'DROP SEQUENCE SEQ_QCNO';
EXECUTE IMMEDIATE 'CREATE SEQUENCE SEQ_QCNO START WITH 1 MAXVALUE 999 MINVALUE 1 CYCLE NOCACHE NOORDER';
end;直接在toad中执行这段是没有问题的,可一但设到job中,第二句总是不执行,不知问题出在哪里?
望高手指点迷津,谢谢
有没有错误代码?
有问题的话 把代码贴出来
EXECUTE IMMEDIATE 'CREATE SEQUENCE SEQ_QCNO START WITH 1 MAXVALUE 999 MINVALUE 1 CYCLE NOCACHE NOORDER';放入job中就无法执行了,但job运行时没看到什么报错信息
怎么样才能利用job创建seqence呢?
execute immediate 'DROP SEQUENCE SEQ_QCNO';
execute immediate 'GRANT CREATE ANY SEQUENCE TO sh_aaa';
execute immediate 'CREATE SEQUENCE SEQ_QCNO START WITH 1 MAXVALUE 999 MINVALUE 1 CYCLE NOCACHE NOORDER';