Top "Clob" questions

Load text files as clob to database

Having problem loading text files into database as clob. Oracle version: Oracle Database 11g EE Release 11.2.0.2.0 NLS_LANG: RUSSIAN_RUSSIA.…

oracle oracle11g clob nls-lang

What is the alternate for deprecated Hibernate.createClob(Reader reader, int length)

Seems like Hibernate.createClob(Reader reader, int length) is deprecated in version 3.6.x And it suggests to use Use LobHelper.…

hibernate deprecated clob

DB2: How to insert a clob with line breaks

I have a simple thing which I want to do, yet is so frustrating in attempting and completing. I just …

sql db2 clob

How to generate JSON in Oracle for a CLOB that is > 32k (e.g. 60,000 characters)?

1 ) I have to make json from oracle select query which has three approach i can follow . SELECT JSON_ARRAY(json_…

sql json oracle plsql clob

String to CLOB with postgreSQL

I'm trying to read a clob from postgreSQL DB, change it, and write it back. I was able to read …

sql postgresql clob

java.lang.AbstractMethodError: oracle.jdbc.driver.T4CPreparedStatement.setCharacterStream(ILjava/io/Reader;J)V

I'm getting the following exception when trying to insert the contents of a CKEditor (for CMS - Contents Management System) …

spring hibernate oracle10g clob

Why does using REPLACE function on CLOB cause increase in CACHE_LOBS...?

I have a requirement to use the built in REPLACE function on a CLOB variable as part of a larger …

oracle plsql clob oracle11gr2

Convert datatype Clob to Varchar2 Oracle

I have an Oracle table with a column of type clob. I want to preserve the column order and change …

sql oracle type-conversion clob varchar2

Oracle Clob Reader issue: Protocol violation

I'm Using java7, jboss7, ojdbc7,hibernate 4. Table has a CLOB column and in domain class the code is something like …

hibernate clob ojdbc

How can I update data in CLOB fields using a >> prepared query << with ODP (Oracle.DataAccess)?

I'm trying to execute a prepared sql query which updates CLOB fields in an Oracle 10g database (10.2.0.1). If I execute …

c# oracle .net-3.5 odp.net clob