存储过程create table单独执行成功,设置成job一直 报错

declare
--------存储过程
create or replace procedure delete_base_target_users Authid Current_User is
begin
execute immediate 'create table tb_test(id number(1))';
commit;
end delete_base_target_users;

--------job
job number;
begin
sys.dbms_job.submit(job => job,
what => 'delete_base_target_users;',
next_date => sysdate+1/(24*60),
interval => 'trunc(sysdate,''mi'')+1/(24*60)');

commit;
end;

https://bbs.csdn.net/topics/392282180

create 前面怎么没有drop table 表都存在了,再建。。

  • (void)layoutSubviews {

    [super layoutSubviews];

    CGFloat createViewW = SCREEN_WIDTH - 60 * SCREEN_Ratio;

    CGFloat titleLabH = 40 * SCREEN_Ratio;
    _titleLab.frame = CGRectMake(0, 0, createViewW, titleLabH);

    CGFloat inputFieldY = CGRectGetMaxY(_titleLab.frame) + 25 * SCREEN_Ratio;
    CGFloat inputFieldX = 15 * SCREEN_Ratio;
    CGFloat inputFieldW = createViewW - 2 * inputFieldX;
    CGFloat inputFieldH = 40 * SCREEN_Ratio;
    _inputField.frame = CGRectMake(inputFieldX, inputFieldY, inputFieldW, inputFieldH);

    CGFloat doneBtnY = 0;
    if (_needInputField) {
    doneBtnY = CGRectGetMaxY(_inputField.frame) + 35 * SCREEN_Ratio;
    } else {
    doneBtnY = CGRectGetMaxY(_inputField.frame) + 15 * SCREEN_Ratio;
    }
    CGFloat doneBtnH = 30 * SCREEN_Ratio;
    CGFloat doneBtnW = 50 * SCREEN_Ratio;
    CGFloat doneBtnX = (createViewW - 2 * doneBtnW) / 3;
    _doneBtn.frame = CGRectMake(doneBtnX, doneBtnY, doneBtnW, doneBtnH);

    CGFloat cancelBtnX = CGRectGetMaxX(_doneBtn.frame) + doneBtnX;
    _cancelBtn.frame = CGRectMake(cancelBtnX, doneBtnY, doneBtnW, doneBtnH);

    CGFloat createViewH = CGRectGetMaxY(_doneBtn.frame) + 20 *SCREEN_Ratio;
    _createView.size = CGSizeMake(createViewW, createViewH);
    _createView.center = self.center;
    }