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 87086170
87086170
-------------------==== Posted via Deja News ====-----------------------
http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Fri Sep 05 1997 - 00:00:00 CEST
