Re: line breaks

From: Andre Ranvik <aranvik_at_state.de.us>
Date: 1997/12/04
Message-ID: <34871305.9E0761C5@state.de.us>#1/1

news.eunet.no wrote:

> But how do you put a line break in a SQL*Loader data file?
>
> Pravesh Godiyal wrote in message
> <01bcfb33$47cdba20$2f0a66a1_at_eusunw2415.rec.bp.com>...
> >This is not a good solution instead a CHR(10) is a good solution for
this
> >problem.

I have the same problem. I want to load data into a "long raw" field, and this works find by specifying the import data as "RAW". The only problem is that I can't find a way of storing line-breaks, since all data is expected to be on one line.

I have tried this:
....<cut>
NOTE RAW(1000) "CHR(10) || :NOTE || CHR(10)" ....<cut>

This should give my note-data with a line-break before and after. What happens is that I get an error message saying that there were a non-hex character.

It works fine if I for instance use CHR(65) instead.

Andre Received on Thu Dec 04 1997 - 00:00:00 CST