Re: loading string > 4000

you can use the long data type ( strings can be 2 GB long) nut it has restrictions. (only one long per table, cannot index it, cannot use functions liek substr on it )

or you can use a CLOB data type.

or simply you could slice your string it into several rows and store it in consequent rows. you could write a little stored proc/function to return the concatenated string back ( in which case it can be upto 32K ) strng

-drey

Barbara Green <bzielink_at_hotmail.com> wrote in message news:fOuc5.2190$Lg1.28852_at_cac1.rdr.news.psi.ca...
> Hi,
>
> I am using 8.0.5 and need to load ASCII files, tab-delimited into Oracle
> tables. The ASCII files might contain strings longer than 4000 chars
> Please help.
>
> Barbara
>
>
>
>
Received on Sun Jul 16 2000 - 00:00:00 CDT