Inserting/Updating Oracle Clob using RCP

clarcombe · Post by **clarcombe** » Mon Jun 27, 2011 9:46 am

I have created an RCP job to upload a group of Peoplesoft tables to a new schema. However, it throws out the following error for a clob

main_program: Unsupported SQL type CLOB or NCLOB for column DESCRLONG.

I can't see an easy way around this except for copying the rcp job to work with a specific LongVarchar column

Any suggestions gratefully received

eph · Post by **eph** » Thu Jun 30, 2011 3:56 am

Hi Colin,

Which Oracle Stage are you using? Oracle Enterprise or Oracle Connector? The second one is way handier for CLOBs.

Eric