一、问题描述
需求要通过JOB定时执行DDL语句(purge recyclbin),来实现清空回收站。简单的问题,由于语法不了解所以报错:ORA-06550 & PLS-00103。让我们来看一下如何在JOB中执行DDL语句的正确语法。
二、测试
1.建立JOB
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => '"TEST_USER"."PURGE_RECYCLBIN_TEST"',
job_type => 'PLSQL_BLOCK',
job_action => 'begin
purge recyclebin;
end;
',
number_of_arguments => 0,
start_date => NULL,
repeat_interval => 'FREQ=WEEKLY;BYDAY=SUN;BYHOUR=0;BYMINUTE=0;BYSECOND=0',
end_date => NULL,
enabled => FALSE,
auto_drop => FALSE,
comments => '每周清理回收站');
DBMS_SCHEDULER.SET_ATTRIBUTE(
name => '"TEST_USER"."PURGE_RECYCLBIN_TEST"',
attribu