SQL*LOAD 32K string Errors
From: Joe Nieto <joe.nieto_at_compaq.com>
Date: 1998/03/23
Message-ID: <01bd56a6$b9afada0$0f9e1cac_at_jnieto.wins.compaq.com>#1/1
Date: 1998/03/23
Message-ID: <01bd56a6$b9afada0$0f9e1cac_at_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 CET