ORA-01704 String Literal Too Long

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 : ORA-01704 String Literal Too Long any help please. -- Please see the official

Re: ORA-01704 String Literal Too Long

: ORA-01704 String Literal Too Long - -any help please. - - - To insert that long a literal, you run up against an SQL*Plus limitation. You'll have to insert it in chunks, keeping track of where the last one ended so you know where to start the next one. -- Bill Thater Certifiable ORACLE

RE: ORA-01704 String Literal Too Long

: Monday, May 21, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: ORA-01704 String Literal Too Long 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