Top "Clob" questions

Extract data from XML Clob using SQL from Oracle Database

I want to extract the value of Decision using sql from table TRAPTABCLOB having column testclob with XML stored as …

sql xml oracle parsing clob

Updating CLOB field in Oracle

I have a table in Oracle database with field with data type CLOB. The name of field is XMLString. I …

oracle clob

Error- ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion

I am attempting to read a blob message and display it as a variable in one of my procedures, but …

sql oracle stored-procedures blob clob

Convert String to Clob in Java

I have a situation where I need to make Clob object from String. The problem is I can't have ConnectionManager …

java sql string clob

Hibernate on Oracle: mapping String property to CLOB column

WARNING: see my own answer below. The problem is caused by old Oracle drivers that were present on the classpath …

java oracle hibernate jpa clob

How to show CLOB type in a SELECT in SQL Server?

I have a table with one column of CLOB type data, they are all very short no more than 20 bytes, …

sql-server database tsql clob

How do I test if a column equals empty_clob() in Oracle?

The naïve FOO = empty_clob() complains about incompatible types. I tried Googling, but (once again) had little success searching …

oracle clob

DB2 cast a large CLOB (> 32KB) into text?

I have a DB2 (9.5.1) table which is defined as follows: CREATE TABLE MY_TABLE ( ID INTEGER DEFAULT 0 NOT NULL, TEXT …

db2 varchar clob

How to create a Clob in JPA in an implementation agnostic way

I am using Ejb3 and JPA (based on Hibernate and Oracle 10g at the moment) I have an entity that …

java hibernate jpa clob

Exporting a CLOB to a text file using Oracle SQL Developer

I am using Oracle SQL Developer and trying to export a table to a CSV file. Some of the fields …

sql oracle clob oracle-sqldeveloper