Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL*Loader (7.3.4.2) and multi-line record

SQL*Loader (7.3.4.2) and multi-line record

From: Dave Brady <brady_at_fas.harvard.edu>
Date: 7 Jul 1998 19:18:13 GMT
Message-ID: <6nts9l$ev9$1@news.fas.harvard.edu>


I'm trying to load, into a LONG datatype, a field which consists of several physical lines from a file, such as:

This will be
one field
in the table|

However, SQL*Loader, despite being told in its control file to delimit columns by "|", gets to "be," and calls it quits.

Any ideas (I hope)?

--

Dave Brady                    FAS Computer Services
Sr UNIX Sys Admin/Programmer  Harvard University
brady_at_fas.harvard.edu         LL1A Science Center
Phone: (617) 495-1273         1 Oxford Street
FAX:   (617) 495-1210         Cambridge, MA 02138
Received on Tue Jul 07 1998 - 14:18:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US