SqlLoader Oracle data with carriage returns

From: Christina Candlena <candlena_at_acsu.buffalo.edu>
Date: Fri, 27 Aug 1999 08:40:54 -0400
Message-ID: <7q610v$kc3$1@prometheus.acsu.buffalo.edu>

I have a data file that I am trying to load into an Oracle table. The field I am having problems with is defined as Long. In some of the records a carriage return is embedded into the data for formatting purposes. The character shows up as a ^M looking at the data through vi or emacs.

The error I receive with SqlLoader is
"Rejected - Error on table tablename, column column_name Ora-02360 Column not found before end of logical record (use trailing nullcols).

Has anyone ever tried loading data with embedded carriage returns. How have others loaded this type of data.

Thanks, Received on Fri Aug 27 1999 - 07:40:54 CDT