Hi all,
I have a Central Database which creates jobs on remote databases through database link. This Central database is a 11.2.0.3.0 database. This central database connects to 9/10/11g databases and the jobs works. Now we have some new 12C databases (SE 12.1.0.1 and EE 12.1.0.2) and on these databases it doesn't work. I get the PLS-00960 when I try to run the job.
My code is the next 1 (argument 2 is simplified, normally more code):
begin
execute immediate 'alter session set remote_dependencies_mode = signature';
begin
dbms_scheduler.drop_job@db816('DF_CHECK_JOB2');
exception when others then null;
end;
dbms_scheduler.create_job@db816(job_name => 'DF_CHECK_JOB2'
,enabled => false
,job_type => 'EXECUTABLE'
,job_action => '/bin/sh'
,number_of_arguments => 2);
dbms_scheduler.set_job_argument_value@db816('DF_CHECK_JOB2',1,'-c');
dbms_scheduler.set_job_argument_value@db816('DF_CHECK_JOB2',2,'ls');
dbms_scheduler.run_job@db816('DF_CHECK_JOB2');
dbms_scheduler.drop_job@db816('DF_CHECK_JOB2');
end;
The error is thrown by the run_job command. If I create the job in the 12c database it works, so no code errors.
Is it possible something internal has canged so there is a type difference and throws the error? I checked Support but no bug found for something similar.
Another step could be to upgrade the central Database to 12c, it is planned but not on short terms.
Update: I tried the same principle from a 12C to a 12C database and also gives the error, so I assume for now a 12C bug
Thanks in advance
Herald ten Dam
Superconsult