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

最新推荐文章于 2024-07-30 08:30:00 发布

原创最新推荐文章于 2024-07-30 08:30:00 发布 · 734 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #job #schedule

oracle 专栏收录该内容

9 篇文章

订阅专栏

本文详细介绍了在使用Oracle数据库调度器创建作业时遇到的错误及其解决方案，重点在于工作类型的正确选择。通过修改工作类型为PLSQL_BLOCK，成功解决了ORA-27452错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Trying to create this job:

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:

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;