Depending on your database version, you maybe able to insert 32K
VARCHAR2 data into your database.
On 06/10/2015 05:12 AM, Jose Soares wrote:
Hi all,
I need to store a lot of data into a single column (more than 4k).
I tried using CLOB because documentation says :
/CLOB data type/
//
/A CLOB (character large object) value can be up to 2,147,483,647 characters long. A CLOB is used to store unicode character-based data, such as large documents in any character set./
//
/The length is given in number characters for both CLOB, unless one of the suffixes K, M, or G is given, relating to the multiples of 1024, 1024*1024, 1024*1024*1024 respectively. /
------------------------------------
When I tried to insert into it more than 4 k a got this error:
(DatabaseError) ORA-24373: invalid length specified for statement
j