apply interval day to second function to character data

[LKBrwn_DBA]

Did you try this in your control file?:

LOAD DATA 
... etc ...
my_interval "TO_DSINTERVAL(:my_interval)",
... etc ...