Re: 2k Limit?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 04 May 1999 21:10:05 GMT
Message-ID: <372f621e.26640396@192.86.155.100>

A copy of this was sent to foo <blah_at_blah.com> (if that email address didn't require changing) On Tue, 04 May 1999 15:29:35 +0100, you wrote:

>How can I insert more than 2k at a time into a LONG datatype?
>
>Thanks!

what language are you using to get stuff in? you need to use bind variables for larger strings instead of character string constants.

One method in SQL plus that works upto 32k is as such:

drop table demo;
create table demo ( x long );

declare

    myvar long default '

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

(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...

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

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 Received on Tue May 04 1999 - 16:10:05 CDT