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