SQL Loader

From: Surendra Singh <ssingh_at_hp1.pepco.com>
Date: 1996/04/24
Message-ID: <4lm1p2$o10_at_news.cais.com>#1/1


I am trying to run SQL Loader on Oracle 7.x on a UNIX machine. The problem I am having is that when one of the inserts gies beyond 80 cols I get a parsing error. I have tryed to break the single line into 2 lines, but I still get errors.

The format is as follows:

  LOAD DATA   INFILE '/ORACLED/SYST01/LOAD/DRS1.DAT'   REPLACE   INTO TABLE dsr_db

    (

    dwg_cntl POSITION(01:18) CHAR,

: : :
: : :
    last_update_date

        POSITION(197:204) CHAR TO_DATE(:last_update_date,'mmddyyyy')",

: : :
: : :
  )

The line with "last_update_date" is longer than 80 characters. Is there a continuation character in SQL Loader?

Thank's

Surendra Singh
ssingh_at_hp1.pepco.com Received on Wed Apr 24 1996 - 00:00:00 CEST

Original text of this message