Can anyone explaining what's happening !!!
Quote:
>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
Quote:
>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
