Re: embedded newlines & sqlldr

Can you supply a sample of the data (flat file) and the sql loader script you are using?

Rob Calfee
trace_at_primenet.com

tornabene_at_my-deja.com wrote in message <7lmkka$jd6$1_at_nnrp1.deja.com>...
>Hi all,
>
>I'm importing data from a Solid database to an Oracle 8.1.5 database
>running on Solaris.
>
>A lot of my varchar data has embedded returns in the data. I cannot
>simply get rid of the embedded returns because it contains formatting
>information that I need.
>
>The sqlldr utility thinks that the embedded returns signify the end of
>the record and dies on those records, because it then thinks the new
>line is the beginning of a new record, which is obviously wrong.
>
>Is there any way to escape embedded returns in varchars so the loader
>doesn't think it's at the end of the record? Can I force it to count
>columns before it looks for a new record (all columns are present in
>every row).
>
>Thanks a lot!
>
>Catherine
>
>tornabenenetscapenet put the @ and . where it seems to fit. :-)
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Sun Jul 04 1999 - 14:56:01 CDT