Using Oracle 11g r2 XE.
If I create the following job using oracle linux user, sqlplus (SYS as SYSDBA):
begin
_dbms\_scheduler.create\_job(_
_job\_name=>'TEST\_JOB',_
_job\_type=>'executable',_
_job\_action=>'/tmp/test\_job.sh',_
_enabled=>FALSE_
_);_
end;
/
I can launch the job without issues:
begin
_DBMS\_SCHEDULER.RUN\_JOB(job\_name=>'TEST\_JOB');_
end;
/
And it works fine.
However, when I try to create exactly the same job under an APEX 5.0.3 schema, when I try to run it I get:
ORA-27369: job of type EXECUTABLE failed with exit code: 274666
