SQL*Loader and Free Form Text
From: John Dixon <john.dixon_at_bsis.com>
Date: 1997/03/04
Message-ID: <01bc28ca$30b1e140$e700010a_at_jdixon-w95.bsis.com>#1/1
Date: 1997/03/04
Message-ID: <01bc28ca$30b1e140$e700010a_at_jdixon-w95.bsis.com>#1/1
I have some data I am trying to load in Oracle via SQL*Loader. One field is free form text which include <CR><LF>'s that I wish to keep. Unfortunately SQL*Loader seems to ALWAYS interpret <CR><LF> as an "End Of Record". This occurs even when I specify field terminators or define fixed length fields.
Has anyone come up with a way o hanlding this problem within SQL*Loader?
-- John Dixon john.dixon_at_bsis.comReceived on Tue Mar 04 1997 - 00:00:00 CET