Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> help with Long datatype

help with Long datatype

From: Sia Akhtary <sia_at_kxab.se>
Date: Thu, 08 Apr 1999 09:20:03 GMT
Message-ID: <370c72a0.857088548@news1.telia.com>


Hi!

I wonder if anyone can help me with some questions about inserting values into a long field.

I have tried the folowing inside the sql plus:

insert into my_test (lng_fld)
values('abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012 abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012');

This gives me an error, either an ORA-01704: string is to long. or an ORA-00972: to long identifier

I would like to insert more then 2000 cahracters in a field, and from the documentation the long type can hold up to 2 gigabytes.

My oracle version is:
Oracle7 Server Release 7.3.2.3.1 - Production Release on NT platform. Received on Thu Apr 08 1999 - 04:20:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US