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

From: fumi <fumi__at_tpts5.seed.net.tw>
Date: 25 Feb 1999 11:21:21 GMT
Message-ID: <7b3bnh$hta$2@news.seed.net.tw>

eswar_oracle_at_hotmail.com ¼¶¼g©ó¤å³¹ <7atvj7$23$1_at_nnrp1.dejanews.com>...
>I am facing very unique problem with SQL Loader.
>This is my control file
>
>load data
>infile 'PRODUCT1.TXT'
>Append
>into table PRODMAST_TEST
>(PRODCODE position (01:05)NUMBER


                                                  ^^^^^^^^^

Since the data in your file are expressed as characters, you can specify the date type "CHAR" in spite of the column data type, as following:

PRODCODE position (01:05) CHAR

>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,
>)
>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
Received on Thu Feb 25 1999 - 05:21:21 CST