dbms_scheduler.create_job
abcdxyzJan 5 2010 — edited May 19 2010Hi all
I am trying to use this to create a job in when button pressed trigger in forms 6i
sys.dbms_scheduler.create_job(
job_name => 'iiii',
job_type => 'EXECUTABLE',
job_action => '/prod1/glif/byer_pr/jobs/glif1sfpay.job' ,
number_of_arguments => 2,
start_date => NULL, --SYSDATE,
repeat_interval => NULL,
end_date => NULL, --'01/01/2006 02:00 AM', --SYSDATE,
job_class => 'DEFAULT_JOB_CLASS',
enabled => FALSE,
auto_drop => TRUE,
comments => NULL);
when i am compiling the form i am getting below Error
"Cannot pass NULL to a NOT NULL constrained formal parameter"
If i pass the parameter sysdate or any date to the start_date parameter then while compiling it gives me the error wrong number of arguments
Please let me know if we can use dbms_scheduler.create_job in forms 6i and if yes how can we use it ?
thanks in advance
Sachin