Problem in using CLOB datatype

HemaV · Post by **HemaV** » Mon Sep 12, 2011 4:51 am

Hi All,
I'm using CLOB datatype column in my Parallel Job and my job is getting aborted with the below errors:
main_program: Unsupported SQL type CLOB or NCLOB for column MSG.
main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: Could not find type: generic

I'm fetching data from table abc and loading into table def, the column MSG has CLOB datatype in abc and def tables
Please guide me on this how to handle in parallel jobs.

Thanks in Advance,

suse_dk · Post by **suse_dk** » Mon Sep 12, 2011 5:23 am

We map the CLOB datatype to NVARCHAR(MAX) (on SQL server 2008 R2)

HemaV · Post by **HemaV** » Mon Sep 12, 2011 6:25 am

suse_dk wrote:We map the CLOB datatype to NVARCHAR(MAX) (on SQL server 2008 R2)

In parallel job I'm using Oracle stage. so how to handle it

Thanks in Advance,