Re: Loading a large text string

Rudy,
This would be possible using a programing language like VC++ or VB using ODBC.
You may also try SQL Loader also. If you need to send me the desc of table and a
record layout and I can generate the sql loader control file to check and send you.

Let me know.

Jed Sousa
Database Administrator
Cherry Semiconductor Corp.
email: gcs_at_cherry-semi.com

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 Thu Jan 15 1998 - 00:00:00 CET