Xref: alice comp.databases.oracle.server:24172
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!dca1-hub1.news.digex.net!digex!news.fas.harvard.edu!not-for-mail
From: brady@fas.harvard.edu (Dave Brady)
Newsgroups: comp.databases.oracle.server
Subject: SQL*Loader (7.3.4.2) and multi-line record
Date: 7 Jul 1998 19:18:13 GMT
Organization: Harvard University, Cambridge, Massachusetts
Lines: 19
Message-ID: <6nts9l$ev9$1@news.fas.harvard.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Newsreader: knews 0.9.8

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@fas.harvard.edu         LL1A Science Center
Phone: (617) 495-1273         1 Oxford Street
FAX:   (617) 495-1210         Cambridge, MA 02138