This content has been marked as final. Show 2 replies
I faced similar problems with unsupported datatype. At the logical layer I used CAST to VARCHAR (similar format you used in Informatica).
For CLOB I used EVALUATE('DBMS_LOB.SUBSTR(%1,4000,1)',"rpd table"."rpd colum") to do similar but found that CAST works also. the DBMS_LOB functions would be more efficient but we were displaying only a small number of records so was no important. Hope they may be use to you in furture.