Load CLOB

dr_personale · Post by **dr_personale** » Mon Oct 04, 2004 11:26 am

Can someone please shed some light on the resolution of the following problem:

I'm using in the Oracle Stage ( PX 6.x DataStage) the options:
Write Method= Load
Write mode= Append.

But i can't load the field CLOB ( Special Oracle data type) , extract like a varchar !
From Director i'm getting error as above:

"Column XXXX has unsupported type. "

NB. If i manually process the same .dat like a sqlloader work's well.

bye, DR.

dr_personale · Post by **dr_personale** » Wed Oct 13, 2004 4:51 am

the only solution about this problem is :

using Upsert mode Loading in Oracle Table
and perform function to_clob()

Bye, D.R.

Hongqing · Post by **Hongqing** » Fri Oct 22, 2004 10:32 am

Hi,

I looked into the ORAOCI Bulk Load and Oracle Express Load. Under Load Mode or Load Action, I did not see "Upsert" selection there. Can you set this up in DataStage? Thanks.

dr_personale wrote:the only solution about this problem is :

using Upsert mode Loading in Oracle Table
and perform function to_clob()

Bye, D.R.