I am trying to plan a load routine for the following:
Every time a file name gets loaded in this table a trigger will fire to perform the following:
1. Start an Oracle Job to passing file name and ctl file name to a shell script.
2. Shell script executes sqlldr routine.
I was hoping to setup this job in the trigger.
dbms_scheduler.create_job(job_name => 'myjob',
job_type => 'executable',
job_action => '/app/oracle/x.sh <filename>, <ctlname>',
enabled => TRUE,
auto_drop => TRUE);
Our developer says he is having trouble passing variable names to the DBMS_JOB call.
Any ideas how to accomplish this process.