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

From: Roy Brokvam <roy.brokvam_at_conax.com>
Date: Tue, 23 Feb 1999 12:07:23 +0100
Message-ID: <7au2b9$cvh$1@readme.online.no>

Hi!

eswar_oracle_at_hotmail.com wrote in message <7atvj7$23$1_at_nnrp1.dejanews.com>...
>
>

[snip]

>
>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,
>)
>

It's been a while since i did any SQL*Loader work, but I am quite certain that you should use "integer external" instead of "number" in the control file.

HTH, Roy Brokvam
roy.brokvam_at_conax.com Received on Tue Feb 23 1999 - 05:07:23 CST