Rem
Rem Changes the interval for the admin job to 30 seconds
RemDECLARE jobno INTEGER;
BEGIN
select job INTO jobno
from dba_jobs
where upper(what) like '%DO_DEFERRED_REPCAT_ADMIN%';
DBMS_JOB.INTERVAL(jobno,'sysdate + (30/(24*60*60))');
END;
/
-----------------------------
DECLARE jobno INTEGER;
*
ERROR 位于第 1 行:
ORA-01403: 未找到数据
ORA-06512: 在line 3----------------
Rem Changes the interval for the admin job to 30 seconds
RemDECLARE jobno INTEGER;
BEGIN
select job INTO jobno
from dba_jobs
where upper(what) like '%DO_DEFERRED_REPCAT_ADMIN%';
DBMS_JOB.INTERVAL(jobno,'sysdate + (30/(24*60*60))');
END;
/
-----------------------------
DECLARE jobno INTEGER;
*
ERROR 位于第 1 行:
ORA-01403: 未找到数据
ORA-06512: 在line 3----------------
if v_i>0 then
select ... into ...
end if;