Loading data using SQLLOADER

From: Richard Fernandez <rferna_at_ctp.com>
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

Original text of this message