Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dbms_scheduler.create_job

849776Sep 19 2011 — edited Sep 19 2011
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2011
Added on Sep 19 2011
4 comments
242 views