Re: Inserting 2000+ char into long?

From: thor hw <thor_at_echidna.net>
Date: 1998/02/17
Message-ID: <1998Feb17.182259.9927@vmsmail.gov.bc.ca>#1/1

You must be an Oracle8 guy, piecewise write isn't available till then.

The literal problem comes from your SQLPlus environment???

This works:
 create table y (y1 long);

 declare

     foo varchar2(32000);
 begin

     for i in 1..5000 loop
         foo := foo||'a';
     end loop;
     insert into y values (foo);

  end;
 /

set long 5000
select * from y;

Makes a string, bigger than 2k and inserts it into the long of the table. Works in Oracle7.x and better.
Thor HW

Kevin P. Fleming wrote in message
<34E9E023.90B9854_at_access-laserpress.com>...
>No, it must be done using API calls (OCI, ODBC, DBMS_LOB, etc.), and it
 must
>be done in chunks.
>
>Freda wrote:
>>
>> How do you put over 2000 char into long field without getting
>> ORA-01704: string literal too long. Is it not possible using a SQL
>> insert statement?
>>
>> Please respond to
>> freda.chatman_at_losangeles.af.mil
Received on Tue Feb 17 1998 - 00:00:00 CST