How to export blob column to an XML file ?

How to export blob column to an XML file ?

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...
Community Manager

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

Hello
Can you upload a screenshot of your tOracleInput schema and what's your expected result?
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

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

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
Community Manager

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

Hello Stéphane
I can't see your screenshot. There is a related 1753
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

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

My screenshot it is correct ?

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

Anybody help me with my beautiful screenshot ? Smiley Happy
One Star

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

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
Six Stars

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

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
One Star

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

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

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

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