One Star

Extract Oracle CLOB datatype as UTF-8 String to a File

I need to download a field from Oracle table. The field is defined as CLOB type in Oracle. (The field contains text data in various format, like, Simplified Chinese, Espaniol, etc.)
Please suggest a way to convert and print on the file.
1 REPLY
Moderator

Re: Extract Oracle CLOB datatype as UTF-8 String to a File

Hi,
If you are working with Oracle, you can use tOracleInput to read the CLOB column (Column Type can be set as Object).
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.