ORA-27452: %s is an invalid name for a database object

Trying to create this job:

1
2
3
4
5
6
7
8
9
10
11
12
13
begin
   -- Test statements here
   DBMS_SCHEDULER.CREATE_JOB (
    job_name             => 'JOB_1',
    job_type             => 'STORED_PROCEDURE',
    job_action           => 'BEGIN USER.PROCEDURE; END;',
    start_date           => sysdate,
    repeat_interval      => 'FREQ=MINUTELY; INTERVAL=5;',
  --  end_date             => NULL,
    enabled              =>  TRUE,
    comments             => 'Get data from api');
    commit;
end;

But i got this error: ORA-27452: %s is an invalid name for a database object
Found out that:
1) the action you are defineing, must be valid (duh)
2) if you are using the action as i am, the type is NOT STORED_PROCEDURE, its PLSQL_BLOCK

so changed it to:

1
2
3
4
5
6
7
8
9
10
11
12
13
begin
   -- Test statements here
   DBMS_SCHEDULER.CREATE_JOB (
    job_name             => 'JOB_1',
    job_type             => 'PLSQL_BLOCK',
    job_action           => 'BEGIN USER.PROCEDURE; END;',
    start_date           => sysdate,
    repeat_interval      => 'FREQ=MINUTELY; INTERVAL=5;',
  --  end_date             => NULL,
    enabled              =>  TRUE,
    comments             => 'Get data from api');
    commit;
end;
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值