clob to long varchar

[dsscholar]

My ddl :
create table test1
(
id number,
ship_xml clob
);

Ds design :

Oracle source ----> Oracle Target

Source query :
select id,dbms_lob.substr( ship_xml, 4000, 1 ) as ship_xml from akrishb.test1
I used the above query as the job failed when i tried with ship_xml alone giving the following error.

Oracle_Enterprise_0: Error when checking operator: Caught parsing exception during wrapDescribeOperator(): Could not find type: oratype:112

So i converted the clob data to varchar then i ran the job. The job completed successfully. but records dint get inserted. 0 rows are getting inserted. when i imported the table definition, it came as long varchar for the ship_xml column. During my query i changed to varchar then ran it. But 0 records got inserted.

Please advise for this scenario.

[dsscholar]

My datastage version is 8.0.1. Expecting some reply in this issue. Please advise.


Thanks in advance

[dsscholar]

Ray,Chulett,jwiles

Can you people atleast reply for my issue.


Thanks in advance

[chulett]

Sure.

I have no clue or I would have replied already. I also would have suggested contacting your official support provider other than the fact that CLOBs are not supported. However, they may know of a workaround or two, can't hurt to ask.

I would also suggest changing your expectations.

[ray.wurlod]

We don't get paid for doing this. Your official support provider does.