using filler fields in sqlldr

I want to load comma separated data with sqlldr generating a date field out of two input data columns.

Here a test case as I feel it should be working:

create table t (beg date);

• test.ctl load data infile * into table t append fields terminated by ',' ( hour filler, day filler, beg "to_date(:hour||' '||:day, 'hh24:mi:ss dd.mm.yyyy')" ) begindata 11:20:23,07.10.2002

But I cannot reference filler fields except in some special functions :-<

SQL*Loader-291: Invalid bind variable HOUR in SQL string for column BEG.

Can this be solved with sqlldr alone or need I to convert the data before passing it to sqlldr?

Richard Received on Sat Oct 19 2002 - 06:01:40 CDT