CLOB / BLOB

[vss]

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

[RamonaReed]

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)

[kris007]

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

[chulett]

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.