Home » RDBMS Server » Server Utilities » SQL*Loader: Loading Data with Carriage Returns/Line Feeds
SQL*Loader: Loading Data with Carriage Returns/Line Feeds [message #72121] Wed, 12 March 2003 07:35 Go to next message
Howard Schisler
Messages: 4
Registered: February 2003
Junior Member
I'm using SQL*Loader to load a table, the last column of which is a LONG datatype. This column will contain resumes. The resumes have many line feeds.
The entire text of the resume, from the input file, is being loaded but the carriage return/line feeds are being ignored. The text is readable after it's inserted into the table, but the lines and paragraphs all run together (i.e., no spacing between them). We'd like to preserve the formatting of paragraphs within the resume.

Do you have suggestions?

I can send the control file, log file, and input file.

Thanks.

Report message to a moderator

Re: SQL*Loader: Loading Data with Carriage Returns/Line Feeds [message #72124 is a reply to message #72121] Wed, 12 March 2003 12:25 Go to previous message
Howard Schisler
Messages: 4
Registered: February 2003
Junior Member
The solution is:
(1) Use "str X'7c'" on the INFILE statement,
(2) Do not use CONTINUEIF at the same time.

Report message to a moderator

Previous Topic: importing constraints only
Next Topic: Import to 1 colunm
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 02:02:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.