Re: Long Fields

From: <tkashin_at_my-deja.com>
Date: 2000/04/07
Message-ID: <8ckqto$mae$1@nnrp1.deja.com>#1/1

In article <d105dsoftfe564s218mg67p2n4r79p7joo_at_4ax.com>,   tkyte_at_us.oracle.com wrote:
> A copy of this was sent to jandrews0919_at_my-deja.com
> (if that email address didn't require changing)
> On Thu, 16 Mar 2000 21:31:31 GMT, you wrote:
>
> >I can insert a text value > 4000 bytes into a
> >long field on one table, but a max of 4000 bytes
> >on another. What simple, stupid thing am I doing
> >to cause this oddity.
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
> Are you inserting into them differently? character string constants
 in SQL are
> limited to 4000 bytes in 8.0 and up, 2000 in 7.x. If you are doing an
 insert
> with a constant (and not a bind variable) you'll hit this.
>
> see http://osi.oracle.com/~tkyte/Misc/LargeStrings.html
>
> --
> http://osi.oracle.com/~tkyte/
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle
 Corporation
>

Mr. Kyte:
We, too, are having this problem: we need to insert large strings (>4000 characters) into an Oracle 8 "long" table column. I tried your program and it returned an error.

declare

        myvar long default
'01234567890123456789012345678901234567890123456789012345678901234567890 [4200 characters here]';

    begin

       insert into tbk values ( myvar );
       dbms_output.put_line( length( myvar ) );

    end;

I received the following error:
MGR-11401: input error, unable to read input line I was using the SQL Worksheet.

Why this seemingly simple process is so complex is beyond me and all these other people who are writing about this issue. Why limit the inserted string to 4000 characters? Why make the data type up to 2GB when you can't ever get it in there?
Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 07 2000 - 00:00:00 CDT