topic How to export blob column to an XML file ? in Talend Studio

How to export blob column to an XML file ?

Anonymous — Sat, 16 Nov 2024 14:20:04 GMT

Hi,
I use an oracle 9.2.0.5, and TOS 2.3.3
I want to extract the content of my oracle blob column in an xmlfile.
I use tOracleInput with tMap to tFileOutputXml, but the result isn't correct

<row>
<ID>1</ID>
<IMAGE>oracle.sql.BLOB@13ad085</IMAGE>
</row>
<row>
<ID>2</ID>
<IMAGE>oracle.sql.BLOB@4fce71</IMAGE>
</row>

How can i do ?
It is possible...

Re: How to export blob column to an XML file ?

Anonymous — Wed, 18 Jun 2008 04:18:02 GMT

Hello
Can you upload a screenshot of your tOracleInput schema and what's your expected result?
Best regards
shong

Re: How to export blob column to an XML file ?

Anonymous — Thu, 19 Jun 2008 16:28:44 GMT

Hello,
I want this result

<ROWSET>
<ROW>
<ID>1</ID>
<IMAGE>3026B2758E66CF11A6D900AA0062CE6C7A0A00.......0020</IMAGE>
</ROW>
<ROW>
<ID>2</ID>
<IMAGE>FFD8FFE000104A464946000101010060006000........606476A181FFFD9</IMAGE>
</ROW>
</ROWSET>

My screenshot it is correct ?
Stéphane

Re: How to export blob column to an XML file ?

Anonymous — Fri, 20 Jun 2008 02:56:45 GMT

Hello Stéphane
I can't see your screenshot. There is a related 1753
Best regards
shong

Re: How to export blob column to an XML file ?

Anonymous — Mon, 30 Jun 2008 11:33:28 GMT

My screenshot it is correct ?

Re: How to export blob column to an XML file ?

Anonymous — Tue, 01 Jul 2008 09:37:59 GMT

Anybody help me with my beautiful screenshot ?

Re: How to export blob column to an XML file ?

willm1 — Fri, 28 May 2010 23:16:03 GMT

Hello,
I have the same issue.... I have a table in Oracle 10g that has a single column of type CLOB. It contains a fully-formed XML file.
I would like to read this table and output the data in the column to an XML file. When I do this using the tFileOutputXML, I get a nothing in the file.
Please help!
Thanks
Will

Re: How to export blob column to an XML file ?

Anonymous — Wed, 10 Nov 2010 08:23:46 GMT

Hello,
I am in the same situation, have XML file in CLOB column in database and want to read it, write it into SOAP template and send it to web service. In my case I try to retreive the CLOB column using database functio. Based on the Talend mapping I tried to get this type of data into Object type, but then error occured. I have workaround for this behavior creating Talend routine on my own, but I lost the beauty of component schema.
As soon as I used tOracleSP component for retreiving CLOB data type I linked the bug to it, progress could be found at:
http://talendforge.org/bugs/view.php?id=16994
Did anyone already find solution related to this issue?
Best regards,
archenroot

Re: How to export blob column to an XML file ?

_AnonymousUser — Fri, 03 Dec 2010 10:14:12 GMT

Hey Even I'm stuck with the same issue.
Need to export clob value to XML file.
Please help.
Thanks in advance!

Re: How to export blob column to an XML file ?

Anonymous — Fri, 03 Dec 2010 12:58:29 GMT

Well this seems to be well resolved issue which I already checked and it works in order.
There was a bad object mapping issue I reported as bug, this was related to both BLOB and CLOB data types. Take again look at the bug report at: http://www.talendforge.org/bugs/view.php?id=16994
Just remember that this issue has been reported to the only component tOracleSP!!! If you experience issues with these data types with different component, you schould report bug new bug or update the on mentioned above, so they could fix this for your component.
To solve this behavior just wait for new release or download already patched files from talend svn server at:
http://talendforge.org/trac/tos/changeset/51410
There are 3 files to download. Steps to make it work:
1.] download the files from SVN
2.] locate the directory of your component in Talend product folder
3.] replace current files with new 3 ones
4.] restart Talend and thats it
from this point the CLOB and BLOB data types are returned as String data type.
Hope it helps.
Best regards,
Ladislav Jech