Re: Help for sqlldr problem

Sure. You can apply a SQL-function to the column etc.

But you can't pass a parameter to SQL*Loader to be used in the controlfile! For such requierements we work with dynamically generated controlfiles:

• the controlfile-template is stored in a table
• SQL+ is invoked with the appropriate parameters and generates the controlfile
• SQL*Loader is invoked

additional benefit: That way we store our controlfiles inside the database and not in the filesystem. Comes in very handy for versioning, delivery and deployment.  

On Wed, 2 Jan 2002 11:19:06 +0100, "Peter Lintner" <peter.lintner_at_sos-kd.org> wrote:

>Hi!
>I had the same problem some years ago with oracle version 7.
>Please read the documentation of sqlldr, i know it is possible, to do that,
>but I changed the company.
>You can use several conditions, what to do with a record (insert, skip etc.)
>HTH
>Petzer
>
>

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Wed Jan 02 2002 - 07:14:17 CST