DSXchange

Hi,

I need to read BLOB/CLOB columns from and Table and insert them in another table.
I dont find any way to read the CLOB/BLOB columns using Oracle Enterprise Stage.
Any inputs will be highly appreciated.

Thanks in advance,
Vss

When you write your query from the Oracle table, you will need to do the following:

select (to_char(BLOB_FIELD)) as BLOB_TXT from SrcTable

And have your column defines as LongVarChar (4000)

As per me, you can't move BLOB datatypes using Oracle OCI. You can move CLOB datatypes by reading it as a LongVarchar(4000).

For recent versions of Oracle, check out the DBMS_LOB package. I've found it helps with handling data of this nature more than using a large (or Long) Varchar datatype by itself does.