Re: Who knows how to load strings longer than 4000 chars?!!!!

In article <juPc5.2297$Lg1.35192_at_cac1.rdr.news.psi.ca>,   "Barbara Green" <bzielink_at_hotmail.com> wrote:
> 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
> It seems nobody knows how to do it, or this is to trivial .....
>
> Barbara
>
>

Hi!
Did you try to use SQL LOADER? May be it could solve all your problems.

OR

To store strings more than 2000 you should use datatype LONG. It allows you to store in DB 32000 symbols. To obtain data more than 2000 symbols you should create stored procedure and
1. Create variable

   Long_str VARCHAR2(32000);
2. Assign value to it

   Long_str := <Value from ASCII file>
3. Use Variable in INSERT statement.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jul 18 2000 - 00:00:00 CDT