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)?