Loading data using SQLLOADER
Date: 1997/09/05
Message-ID: <873478934.28776_at_dejanews.com>#1/1
I am attempting to insert via SQLLoader a file which has a field that
exceeds 256 characters. The problem is that the field is inserted
into a
column described as a VARCHAR2(2000). The control file has been
specified
to use a char(2002) datatype. I am also using a command line
specifying
the rows =1 and bindsize = 5116. Upon execution an error is return as
follows:
$ SQLLOAD USERID=/,
CONTROL=APPLN_DT:[IMR_COMMON.AMW.LOAD]AMW183.ctl, L
OG=APPLN_DT:[IMR_COMMON.AMW.LOG]amw183.log,
DATA=APPLN_DT:[IMR_COMMON.AMWRL]AMW183
.TXT, ERRORS=100000, ROWS=1, BINDSIZE=5116
SQL*Loader: Release 7.1.5.2.3 - Production on Fri Sep 5 12:51:16 1997
Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
%SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual
address=00000000, PC=8
048ECB8, PS=0000001B
%TRACE-F-TRACEBACK, symbolic stack dump follows
Image Name Module Name Routine Name Line Number rel PC abs
PC
0 8048ECB8 048ECB8 SQLLDR ULN ulnafl 49923 00000EC4 03C4F734 SQLLDR ULN ulnapr 50572 000025F0 03C50E60 SQLLDR ULN ulnlwr 50270 00001D1C 03C5058C SQLLDR ULN ulnl 50169 00001840 03C500B0 SQLLDR ULMAI ulmcep 51051 0000282C 03C33DEC SQLLDR ULMAI main 50858 00001F50 03C33510 SQLLDR ULMAI __main 0 00000058 03C31618 0 8708617087086170
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Fri Sep 05 1997 - 00:00:00 CEST