SQLLOAD restricts to 256 chars?
From: Samir Patil <samirpatil_at_hotmail.com>
Date: 1997/09/09
Message-ID: <873490709.9433_at_dejanews.com>#1/1
Date: 1997/09/09
Message-ID: <873490709.9433_at_dejanews.com>#1/1
I am facing a problem to load data from a datafile to database table
using sqlload.
I have a field in datafile which can be as long as 2000 characters.
And the field in the table is defined as varchar2(2000). So apparantly
there should not be any problem loading 2000 characters in that field;
but sqlload rejects the records in the datafile which has more than
256 characters for that particular field.
I need to know how can I get around this restriction of sqlload.
Is there any parameter that is to be set ? (bind array size ?)
I am using sqlload on Vax/Vms
Please reply asap.
-------------------==== Posted via Deja News ====-----------------------
http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Tue Sep 09 1997 - 00:00:00 CEST
