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