Re: inserting into a long field more than 2000 characters

Maiko,

There is a way to tackle this, if the text size is less than or eqal to 32K.

Use the following method :

Assume, you have already created a table called My_Table with a column Long_Data of type long.

declare

    mylongdata long default '

#######################################################

   insert into My_Table (Long_Data) values ( mylongdata ); end;

Now the text has been inserted into the table..

Good Luck

Raju

On Wed, 07 Jul 1999 13:36:56 GMT, maiko_at_dds.nl (Maiko) wrote:

>How do I insert more than 2000 characters at once in a long field
>thorugh SQL*PLUS or PL/SQL?
>
>Please help me,
>
>thanks in advance,
>
>Maiko
Received on Fri Jul 09 1999 - 16:14:21 CEST