Dbms_scheduler.create_job
849776Sep 19 2011 — edited Sep 19 2011Hi gurus,
iam trying to run a package.procedure using dbms_scheduler.create_job .
The job created all right but the procedure is not executed.
Tried executing the procedure alone and it works
BEGIN
DBMS_SCHEDULER.
create_job (
job_name => 'PROCEDURE TOBE_SCHEDULE',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN pkg.TEST_PROC (-8); END;',
start_date => SYSDATE,
end_date => NULL,
repeat_interval => 'FREQ=DAILY; BYHOUR=15;',
enabled => TRUE,
comments => 'PKG_LOAD');
END;
/
Job was running as scheduled every day at 3 pm but the status is failed(the procedure is not executing) in dba_scheduler_job_RUN_DETAILS and
Iam getting error as :
ORA-06550: line 1, column 765:
PLS-00302: component 'TEST_PROC' must be declared
ORA-06550: line 1, column 756:
PL/SQL: Statement ignored;
Thanks in advance