One Star CA
One Star

CLOB and BLOB - invalid LOB pointer

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
3 REPLIES
Seventeen Stars

Re: CLOB and BLOB - invalid LOB pointer

Writing BLOBs and CLOBs are not currently supported by Talend Studio yet.
You can download BLOBs and CLOBs with the component tLOBDownload from Exchange but so far there is no build-in way to upload them.
https://www.talendforge.org/exchange/index.php?eid=1277&product=tos&action=view&nav=1,1,1
To upload you have to do this with your own Java code (obviously it is possible but not only with drag&drop components to your job).
One Star CA
One Star

Re: CLOB and BLOB - invalid LOB pointer

Hello,
That's a shame Smiley Happy ! But thanks for the help...I'll definitly check out the componant.
Regards
Claire
Seventeen Stars

Re: CLOB and BLOB - invalid LOB pointer

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.