This is from Oracle's TechNet Sample Code:
One method in SQL plus that works upto 32k is as such:
drop table demo;
create table demo ( x long );
declare
myvar long default '
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
x
(lots of stuff here)......
';
begin
insert into demo values ( myvar );
dbms_output.put_line( length( myvar ) );
end;
The pl/sql variable can be initialized to upto 32k of static text. It can
then
be inserted into the table (it is a bind variable, not a constant at that
point).
For example, I just ran it and it showed me:
Table dropped.
Table created.
24726
PL/SQL procedure successfully completed.
So, that put a 24,726 character string into the table...
Hope this helps
Steve Brown
Sia Akhtary <sia_at_kxab.se> wrote in message
news:370c72a0.857088548_at_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('abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghi
jklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz0
12
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012
>abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopq
rstuvwxyz012abcdefghijklmnopqrstuvwxyz012abcdefghijklmnopqrstuvwxyz012');
>
>
>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 - 23:36:35 CDT