Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Loading a large text string
Hi,
I don't think you can do any field longer than 32K in SqlPlus. I use PL/SQL to overcome this problem last time.
You may try this too.
David Ng
Rudy Aceves <raceves_at_vengrp.com> wrote in article
<69cdtl$gok$1_at_news.ncal.verio.com>...
> Hello,
>
> I having a problem loading a large text string which is about
> 100,000 characters in length into a LONG field inside of an
> Oracle database. I'm using the plus33.exe Oracle utility for
> Windows 95/NT to run an insert script. I loading into a Oracle
> 7 server running on HP-UX 10.20.
>
> The error I keep getting is the string literal is too long. The LONG
> field is supposed to hold up to 2GB of data. So I believe it's a
> limitation of the plus33.exe/sqlplus utility for Windows.
>
> Has anyone run into this problem before? Any work arounds?
>
> Thanks,
>
> - Rudy.
>
> raceves_at_vengrp.com
>
>
>
Received on Tue Jan 13 1998 - 00:00:00 CST