Skip to Main Content

Oracle Forms

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

abcdxyzJan 5 2010 — edited May 19 2010
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2010
Added on Jan 5 2010
13 comments
4,082 views