Maxmix
Member³
Hello,
I am editing the scheduler job in DBMS Scheduler form in PSD, where the following procedure is to be called:
My job_type is 'Stored procedure'.
Now I cannot to modify the value of the argument P_EMAIL_TO (which is named "1" on the form).
If I press View SQL button, I see the following generated block (which does not execute, of course):
Why do I see so strange argument_position (in 9.0.6.1670 version)?
I am editing the scheduler job in DBMS Scheduler form in PSD, where the following procedure is to be called:
SQL:
SQL> desc refresh_dogs
Parameter Type Mode Default?
---------- -------- ---- --------
P_EMAIL_TO VARCHAR2 IN Y
My job_type is 'Stored procedure'.
Now I cannot to modify the value of the argument P_EMAIL_TO (which is named "1" on the form).
If I press View SQL button, I see the following generated block (which does not execute, of course):
SQL:
begin
sys.dbms_scheduler.set_attribute(name => 'HEATBILL.OMNIS_REFRESH_DOGS', attribute => 'job_action', value => 'HEATBILL.REFRESH_DOGS');
sys.dbms_scheduler.set_job_argument_value(job_name => 'HEATBILL.OMNIS_REFRESH_DOGS',
argument_position => to_date('31-12-1899 00:00:00', 'dd-mm-yyyy hh24:mi:ss'),
argument_value => '');
end;
/
Why do I see so strange argument_position (in 9.0.6.1670 version)?