Re: SQL*Loader Question
From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Tue, 20 Jun 2017 13:13:59 -0500
Message-ID: <3d043ac4335e639a00962324d03686c4_at_society.servebeer.com>
Date: Tue, 20 Jun 2017 13:13:59 -0500
Message-ID: <3d043ac4335e639a00962324d03686c4_at_society.servebeer.com>
On 2017/06/20 12:58, Scott Canaan wrote:
> [snip] Then list the columns. Near the end is a very long column (comment1) which is defined as varchar2(3000) in the database. SQL*Loader will load all of the rows fine, except those that have quotes around the comment1 field. I can't figure out how to get it to load those rows and why it's having trouble with the quotes ("). I'm sure it's something really simple, but I just can't see it.
Are you sure the quotes are CHR(34) and not CHR(14844060) and CHR(14844060)? There's probably some "fun" around the character set of the file as well...
Just a thought.
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 20 2017 - 20:13:59 CEST