Top "Clob" questions

Extract specific value from CLOB (containing XML) while creating one delimited string per row of a table. CLOB value may be null on some rows

Some Context: The DB is Oracle. I am trying to create one delimited string per row of a table. Some …

sql xml oracle clob xmltype

java.lang.ClassCastException: oracle.sql.CLOB cannot be cast to oracle.sql.CLOB

I recently upgraded an application to run using JAVA 7 and JBoss 7.1.1 This application was originally developed on JAVA 5 and Jboss 4.2.2. …

java hibernate jboss clob

SQL - How do you compare a CLOB

in a DB2 trigger, I need to compare the value of a CLOB field. Something like: IF OLD_ROW.CLOB_…

sql triggers db2 compare clob

"ORA-01036: illegal variable name/number\n" for oracle clob in C#

When I try to create an oracle stored procedure call with clob input and output in C#, I get the …

c# oracle clob

Java: Clob to byte[]

How can I read a java.sql.Clob into a byte[]?

java sql bytearray clob

How to return temporary CLOB instance from stored function in Pl/SQL?

My stored function creates temporary LOB instance using: Dbms_Lob.CreateTemporary(BUFFER, TRUE, Dbms_Lob.SESSION); where BUFFER is a …

oracle plsql clob

Saving and retrieving CLOB data greater than 32K in Oracle Apex

My aim is to retrieve CLOB data from the database into a textarea in an Oracle Apex application and then …

plsql onload oracle-apex clob

Oracle: LONG or CLOB?

From these two threads, Why is LONG an issue with Oracle? Is it possible to read a CLOB from a …

database oracle clob

Lazily loading a clob in hibernate

There's a lot one can find about this googling a bit but I haven't quite found a workable solution to …

java hibernate jpa clob lob

Inserting Clob with NamedParameterJdbcTemplate

I usually use the lobHandler + JdbcTemplate + PreparedStatementSetter triplet to insert my Clob into the database, as I saw on http://…

java database spring clob