CLOB > 4k

From: Jose Soares <jose.soares_at_sferacarta.com>
Date: Wed, 10 Jun 2015 11:12:37 +0200
Message-ID: <5577FF85.7090402_at_sferacarta.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 10 2015 - 11:12:37 CEST

Original text of this message