SQL*Loader with external parameters [message #74361] |
Thu, 25 November 2004 06:18 |
Diego
Messages: 7 Registered: August 2000
|
Junior Member |
|
|
Hello everybody
I've got a little problem with SQL*Loader. I need to write a CTL being
able to receive an external parameter (that is, a string with the name
of the file to be loaded) in order to include it into a DB field. In
other words, I need something similar to the parameter "USER" or
"SYSDATE" (which are accesible from inside the CTL) but coming from an
extra parameter of the calling to the sqlldr itself or in any other
way/shortcut (without being part of the datafile, of course).
Thanks a lot
Diego
|
|
|