Re: Error messages from using SQL*Loader

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1997/02/15
Message-ID: <5e3guk$h06$1@newton.pacific.net.sg>#1/1

chuacl_at_iscs.nus.sg (Motley Crue, Vaxxer) wrote:
>When I tried to use the sqlload program using the below control file
>
>
>LOAD DATA
>INFILE 'test.dat'
>INSERT INTO TABLE TESTING
>(T1 POSITION(1:5) VARCHAR2(20),
> T2 POSITION(7:12) VARCHAR2(20))
>
>
>I got error messages in the log file given below
>
>
>SQL*Loader: Release 7.2.2.3.0 - Production on Sat Feb 15 12:26:12 1997
>
>Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>
>Is there anything that I have missed out? TIA.
>
>--
>Choon Leong

Hi there,

I feel that you should Remove the single quotes in the 2nd line.

Good Luck

N.Prabhakar Received on Sat Feb 15 1997 - 00:00:00 CST