SQL*Loader with external parameters

From: irocco <diegoapa_at_wanadoo.es>
Date: 18 Nov 2004 02:34:57 -0800
Message-ID: <ae17d02b.0411180234.258861fa_at_posting.google.com>



[Quoted] 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 Received on Thu Nov 18 2004 - 11:34:57 CET

Original text of this message