Re: CLOB > 4k

Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

j

On 10/06/2015 16:18, Mladen Gogala (Redacted sender mgogala_at_yahoo.com for DMARC) wrote:
> 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
>
>
> --
> Mladen Gogala
> Oracle DBA
> http://mgogala.freehostia.com

--
http://www.freelists.org/webpage/oracle-l