SQL Loader
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