SQL*LOAD 32K String

From: Joe Nieto <joe.nieto_at_compaq.com>
Date: 1998/03/23
Message-ID: <01bd56a8$6bdd4680$0f9e1cac@jnieto.wins.compaq.com>#1/1

Hi,

I am attempting to SQL*LOAD a 32K string into a LONG datatype on Oracle 7.3. So far, I have determined that loading the data string only works if it's shorter than about 5K. Anything over that aborts with this message:

Record 1: Rejected - Error on table CREDIT_REPORT_DNB. ORA-01461: can bind a LONG value only for insert into a LONG column

The CREDIT_REPORT_DNB table has a long datatype that I am using to put the string in.

The control file goes something like this: column1...
column2...
:
dnb_user_data char(32000) "ltrim(rtrim(:dnb_user_data))"

Any help would be appreciated!

joe.nieto_at_compaq.com Received on Mon Mar 23 1998 - 00:00:00 CST