CLOB

How to convert LONG to CLOB or to VARCHAR type in select statement

Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...

Conversion of table into XML

How to load a table into XML in a CLOb using Oracle 8.1.4

Hibernate with clob type

I am using clob of oracle 10 g in hibernate. When i tried to insert 5000lines of HTML code to the variable in jave, i am getting the following error; Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.citi.gicap.bpm.ver.domain.Notes];...

Handling null values in XMLType function

I have xmlfile stored in table in CLOB column.It contains some null rows with some spaces. While parsing that column, am using xmltype function on that column, then it is giving error :LPX-00229 input source is empty, beacuse of null clob columns. I have to craete an function index also using...

DTS of TEXT to BLOB or CLOB

Is there a maximum size to DTS from text to a Blob or clob ?

AR server

we r using the AR server 7.0 the backend database is sql 2000 under window platform, so now if I need to change the database table format to CLOB then, any one could tell me what is the format of changing the database format, I mean the table format to In-row and Out-row method. Could any one...

Tagged text in Windows to be inserted into Db2 Clob column on Mainframe

I have a string-combinatino of rich text and tagged test: ex: "test msg <p><STRONG></P>" on Windows machine. How i can insert data 'AS IS' without any data loss into a Db2 clob column. Db2 is residing on mainframe and we are using Db2 version 8.

Table partitioning, CLOB and BLOBs in DB2 9 LUW?

Hi all, My shop has decided that we will take advantage of DB29 table partitioning for some of our large tables. Some of these table have CLOB, LOB and BLOB columns. We intend to split the large tables across several storage objects. I am looking for someone who have done table partitioning and...