Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: variables with SQLLOADER


    I have a process whereby I pick up a file from an FTP server. I would like to pass a variable file name to a control file and also strip out another piece of information from the file name to use to load as a value to the oracle table. Is it possible to
    - pass variables to a control file
    - reference variables within a control file
    - pass variables as values to the table

    I would appreciate any information on the feasibility of this and any examples if it is possible

    many thanks Kerrie

  2. #2
    Join Date
    Apr 2003
    Greenville, SC (USA)
    Here's a script I've used in the past to dynamically create a controlfile... You should be able to modify this and use dynamic SQL to fit your needs

    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts