Re: SqlLdr and multiline records

I'm afraid the TERMINATED BY phrase is not that flexible. You can specify whitespace, a quoted character or a hex byte, and optionally some sort of enclosure. Perhapse a tilde (~) could be inserted between fields?

Scott Vickery wrote in message <35004df5.23240922_at_dggis.rtpnc.epa.gov>...
>I need to use SqlLdr to load fields into a table where the fields are
>not arranged in columnar format. That is Field 1 will be in the ASCII
>file with several lines of text. Field 2 will be seperated by Field 1
>by one blank line, Field 3 willl be seperated from Field 2 by one
>blank line, and so on. Basically, like this:
>
> Field 1: A lot of text goes here that can wrap to multiple lines
>(like this .....)
>
> Field 2: Same as field 1 above
>
> Field n:
>
>
>Is there a way to do this with SqlLdr?
>
>Scott Vickery
Received on Mon Mar 09 1998 - 00:00:00 CET