Re: ORA-01704 String Literal Too Long

2001-05-21 Thread Thater, William
On Mon, 21 May 2001,benajam lhoussain scribbled on the wall in glitter crayon: -Hi, I created a table with a LONG type. From what I read in the Oracle docs -LONG supports up to 2 gigs of data. But I am not able to insert more than -4000 characters into that field. -i have this message error :

RE: ORA-01704 String Literal Too Long

2001-05-21 Thread Saj Raza
Benajam, If you know it you can use Perl, with something like the code below which will insert a string containing the value I_inserted_a_long_abcd1234567890qweerrtrtyyuuiiioooppp concatenated a 10 times, and replace $long_field with your own data or do a loop to read it in from