Re: Help with SQL*LOADER

From: <prochak_at_my-dejanews.com>
Date: Thu, 08 Oct 1998 13:05:07 GMT
Message-ID: <6vida3$hp5$1@nnrp1.dejanews.com>

You neglected to declare the data types of the columns to the loader. instead of ( A, B ) you need (
A CHAR,
B CHAR
)

In article <361b860c.6017737_at_news.telepac.pt>, pedrofigueiredo_at_mail.telepac.pt (Pedro) wrote:
> My control File :
>
> LOAD data INFILE * APPEND into table lixo2
> fields terminated by ','
> ( A,B )
> begindata
> 12,0
> 10,1
>
> My table :
>
> A VARCHAR2(10)
> B VARCHAR2(10)
>
> My load.log
>
> SQL*Loader-925 Error while parsing a cursor (via ocisq3)
>
> Cause: An internal error has occurred.
> Action: Check the message below this one in the log file for more
> information. The table or column referenced may not be accessible.
>
> ORA-00904: invalid column name
>
> Can you help me with this ?
>
> Thank you in advance
>
> pedrofigueiredo_at_mail.telepac.pt
>
>

--
Ed Prochak
Magic Interface, Ltd.
440-498-3702

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 08 1998 - 08:05:07 CDT