Re: sqlldr: Field in data file exceeds maximum length?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 22 May 2007 10:01:58 -0700
Message-ID: <1179853319.476294_at_bubbleator.drizzle.com>


Phil Lawrence wrote:
> Can anyone see why sqlldr thinks the last field in the below example
> record exceeds maximum length?
>
> I show the last field as 1001 characters, including the newline. That
> equals 1000 without the newline, and that is the fieldsize,
> CHAR(1000).
CREATE TABLE test (
testcol VARCHAR2(4000));

Load into this table ... then:

SELECT MAX(LENGTH(testcol)) FROM test;

Two thoughts. The first is that your assumption about the size is incorrect. The second is CHAR(1000)? You've got to be kidding.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue May 22 2007 - 19:01:58 CEST

Original text of this message