SQL*Loader: How do I load more than 300 characters long fields

Hi,

In a .csv file I have something like this:

John,Then something very very very long about 300

characters......................................................................
................................................................................
......................................................,99

I am trying to load it into a table with

create table test(
name varchar2(10),
comments varchar2(500),
age varchar2(10))

Although the comments field is varchar2(500), SQL*Loader will reject anything
longer than 255 characters with this error:

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

  What can I do to load the 300 characters field into the comments field? Received on Thu Sep 02 1999 - 01:22:46 CDT