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


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

Original text of this message