Is it possible to call out the file path from a column in a table to dynamically run multiple import files?
My script currently is
$sqlldr userid=XX/XX control=C:\Users\Richard\Desktop\inserttest.ctl log=C:\Users\Richard\Desktop\inserttest.log;
$sqlldr userid=XX/XX control=(select ctlfilepath from MASTERDATA where Table_Name='BOM') log=(select logfilepath from MASTERDATA where Table_Name='BOM');
However, you might want to consider using external table, rather than sqlloader. Using external tables, you can dynamically modify the files that make up an external table.