DSXchange

the only solution about this problem is :

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

Bye, D.R.

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 ...