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
: 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
: 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