Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can anyone explaining what's happening !!!

Re: Can anyone explaining what's happening !!!

From: <shaji_vps_at_my-dejanews.com>
Date: Thu, 25 Feb 1999 23:18:39 GMT
Message-ID: <7b4lo5$q46$1@nnrp1.dejanews.com>


I just noticed an error in your controlfile. U missed a comma after the PRODCODE position (01:05)NUMBER datatype of your first field. Will this might be the problem ?

Shaji
Shaji_vps_at_hotmail.com

In article <7atvj7$23$1_at_nnrp1.dejanews.com>,   eswar_oracle_at_hotmail.com wrote:
>
>
> I am facing very unique problem with SQL Loader.
>
> This is my Table
>
> SQL> desc prodmast_test
>
> Name Null? Type
> ------------------------------- -------- ----
> PRODCODE NUMBER(5)
> PRODDESC VARCHAR2(25)
> LABCODE VARCHAR2(4)
> LAUNCHMY NUMBER(6)
> UPDPERIOD VARCHAR2(4)
> GENERIC_FLAG VARCHAR2(1)
> DELFLAG VARCHAR2(1)
>
> This is my control file
>
> load data
> infile 'PRODUCT1.TXT'
> Append
> into table PRODMAST_TEST
> (PRODCODE position (01:05)NUMBER
> PRODDESC position (06:25)char,
> LABCODE position (26:29)CHAR,
> LAUNCHMY position (30:35)NUMBER,
> UPDPERIOD position (36:39)char,
> GENERIC_FLAG position (40:40)char,
> DELFLAG position (41:41)char,
> )
>
> This is my data in PRODUCT1.TXT ( I am testing with this two lines only)
>
> 18157BIOPHYLLINE 46151019891S92
> 57546SUPA HI-PROTEIN 48601119892S93 N
>
> (Above positions are not aligned but actually positions are as per control
> file)
>
> when I run the control file I am getting below error
>
> SQL * Loader 350
> Syntax error at line 5
> expecting valid column specification, or ",")", found "NUMBER"
> PRODCODE position (01:05)NUMBER
>
> If you see the data seems to be OK. Then why it is giving that error.
>
> If I change ALL Datatype FROM NUMBER to VARCHAR it is OK.
>
> Can any one explain what's wrong with my contol file.
>
> Please reply to eswar_oracle_at_hotmail.com
>
> Thanks In advance
>
> Eswar
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 25 1999 - 17:18:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US