OraFAQ Forum: Server Utilities » Cannot format columns in the control file

Home » RDBMS Server » Server Utilities » Cannot format columns in the control file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cannot format columns in the control file [message #71761]

Tue, 07 January 2003 15:19

Vitaliy Selivanov
Messages: 4
Registered: January 2003

Junior Member

Hi,

I am loading data from a "&#124" delimited flat file. In the table into which I am loading the data I have a column "TEXT varchar(255)". Sometimes in the data file the length of this field exceeds 255 which causes SQL*Loader error. In my control file I tried to trim the data coming from the flat file :

( .... TEXT CHAR "substr(TEXT,0,254)" ... )

But there is still a loading problem :

Record 1: Rejected - Error on table
, column TEXT. Field in data file exceeds maximum length

Thanks in advance.

Report message to a moderator