topic Re: CLOB and BLOB - invalid LOB pointer in Talend Studio

CLOB and BLOB - invalid LOB pointer

Anonymous — Mon, 12 Jan 2015 16:11:36 GMT

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

Re: CLOB and BLOB - invalid LOB pointer

Anonymous — Tue, 13 Jan 2015 07:54:29 GMT

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).

Re: CLOB and BLOB - invalid LOB pointer

Anonymous — Fri, 16 Jan 2015 17:23:05 GMT

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

Re: CLOB and BLOB - invalid LOB pointer

Anonymous — Sat, 17 Jan 2015 09:32:52 GMT

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.