Hello, I'm trying to do a simple job to transfer data from one database to another with tOracleInput -- Tmap -- TOracleOutput One of the colomn is of datatype CLOB ( in the input table as well as in the output table ) and it translates in Talend as an Object Type. My problem is that when I try to run the job, I get an error : ORA-22275: le pointeur de LOB indiqué n'est pas valide ( invalid LOB pointer ) I'm using Talend for Open Studio MDM 5.5.1 and Oracle 10g Thank you for your help ! Claire
Think about, a CLOB / BLOB can reach a huge size and the download and upload of these kind of data are not completely standardised over the vendors. Actually I would always prefer to transfer the data in a asynchronous way - that is it what the mentioned component does. The normal read and write operations does not work here. I guess this is the reason why Talend has not implemented this feature yet.