Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> help with Long datatype
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
![]() |
![]() |