How to create control file and pass filename dynamacaly into it to execute through sqlldr?

See more:

Oracle

Hi all,

I have setup control file to load data from sqlldr to oracle table.
My filename is not static for example

ISURE_Transaction_Data_20191231

it comes like this on daily basis with date change.
So when i execute control file through scheduler it should take dynamic date.

Suppose if any new file comes like

ISURE_Transaction_Data_20200101

it will fail.

How can i achieve this?Any help would be greatly appreciated.

What I have tried:

OPTIONS(skip=1)
LOAD DATA
INFILE 'D:\code\ISURE_Transaction_Data_20191231.txt'
APPEND
INTO TABLE isure_temp
fields terminated by '|'
TRAILING NULLCOLS
(
CUSTCODE ,
URN_NO ,
TRANSACTION_AMT,
IBANK_TRNX_ID ,
INSTR_TYPE ,
ISURE_PAY_REF_NO ,
FILED_1 ,
FILED_2 ,
FILED_3 ,
FILED_4,
FILED_5,
FILED_6 ,
FILED_7 ,
FILED_8 Date "DD-MM-YYYY",
FILED_9,
FILED_10,
FILED_11,
FILED_12,
FILED_13,
FILED_14,
FILED_15,
FILED_16,
FILED_17,
FILED_18,
FILED_19
)