DBMS Scheduler does not permit changes

Maxmix

Member³
Hello,

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)?
 
This is a bug in the test version (9.0.6.1670) you are using. It will be fixed for the next release. You should use the currently published version to fix the error.
 
Back
Top