Running a procedure with DBMS_SCHEDULER
922659Mar 8 2012 — edited Mar 12 2012Hi guys
I scheduled a job to run a PROC which calls an other PROC to send some notifications
job gets created but when I try to run it i get this error
JOB
BEGIN
DBMS_SCHEDULER.CREATE_JOB(job_name => 'sub.email_notifications5',
job_type => 'stored_procedure',
job_action => 'admin.send_mail',
start_date => '08-MAR-12 10.21.00AM US/MOUNTAIN',
end_date => '08-MAR-12 11.00.00AM US/MOUNTAIN',
enabled => TRUE,
comments => 'Email_Notifications');
END;
/
_Running JOB
BEGIN
DBMS_SCHEDULER.run_job(job_name => 'sub.email_notifications5',
use_current_session => FALSE);
END;
/
_ORA-06550: line 2, column 49:
PLS-00306: wrong number or types of arguments in call to 'SEND_MAIL'
ORA-06550: line 2, column 49:
PL/SQL: Statement ignored
any suggestions ?