Referencing parameter value within a SQLLDR control file

Hi,
I have sqlldr script whose control file looks like this -

INSERT NTO TABLE TEST
FIELDS TERMINATED BY '|'
(
COL1,
COL2,
COL3 "<data filename>"
)

The value in COL3 is a constant and it should be the data file name that I have passed the sqlldr utility using the "data" parameter. My question is how can I reference the value of the data parameter within the sqlldr control file.

Any suggestions would be appreciated.

thanks Received on Mon Jan 15 2007 - 16:27:46 CST