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,
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-lReceived on Wed Jun 10 2015 - 11:12:37 CEST