Re: SQLLDR80 question - getting as much text input as possible?

I don't have the docs here at home, but I remember using functions with v7x to process the data from the flat file. A SubStr(thisfield,1,4000) might do the trick. I'll look for it when I get to the office tomorrow.

John Wunderly <johnwunderly_at_fast.net>

Paul Wagner <wagner_at_cs.umn.edu> wrote in article <6l98ms$ja6_at_epx.cis.umn.edu>...
> I'm trying to load some data into Personal Oracle for Win95, v. 8.0.3.
> The problem is that the relevant field is varchar2, with a max. limit of
> 4000 characters, and some of the data to load is >4000 chars. in length.
> SQLLDR80 rejects these records with more data than the field can handle.
> Is there any way of getting in the *first* 4000 characters, essentially
> truncating the input data at the 4000 char limit and just storing that
> much? Couldn't find any way of doing this in the SQLLDR docs, but if
> there is any way of doing this with a varchar2 field I'd much appreciate
> any ideas or information.
>
> Thanks,
>
> Paul
>
>
> --
> * * * * * * * * * * * * * * *
 *
> * Paul J. Wagner School - wagner_at_cs.umn.edu
 *
> * Computer Science Department Work - wagnerp_at_uwstout.edu
 *
> * University of Minnesota
 *
>
Received on Thu Jun 11 1998 - 02:46:40 CEST