Create a job from dbms_scheduler with stream redirection?
I found a patch to this problem. The idea is to create a bash file:

#!/bin/sh
echo $1 &gt; $2


And now, you can create and run your job:

exec dbms_scheduler.create_job('write_file','executable','/usr/bin/oracle/transfer',2,auto_drop=&gt;false);
exec dbms_scheduler.set_job_argument_value('write_file',1,'some_text');
exec dbms_scheduler.set_job_argument_value('write_file',2,'/tmp/some_file');
exec dbms_scheduler.run_job('write_file');


And you can see the result:


$ cat /tmp/some_file
some_text