https://community.qlik.com/t5/Talend-Studio/text-file-to-clob/m-p/2247684#M32790 It can be done this way:<BR />Use the tFileInputDelimited and configure row separator and field separator with values never exists in your file. This way, this component reads the whole file.<BR />Configure the schema to have only one column (e.g. name it content and use String as type).<BR />I guess your target table has a key field? - I would suggest using a key field, your file name looks like a nice key.<BR />tFileInputDelimited ---&gt; tMap (set values for your key field) ----&gt; tOracleOutput<BR />This subjob should be called within a iteration from tFileList.<BR />Now your job reads all files from a directory and stores them in the oracle table.<BR />For this use case in the tOracleOutput I would strongly recommend switch off the batch processing and use 1 as commit size. Mon, 21 Oct 2013 11:25:01 GMT Anonymous 2013-10-21T11:25:01Z https://community.qlik.com/t5/Talend-Studio/text-file-to-clob/m-p/2247683#M32789 In talend, I want to read set of a text files and insert into oracle db as clob type using java?<BR />How to convert text file to clob ?<BR />Any help appreciated . Mon, 21 Oct 2013 07:41:08 GMT https://community.qlik.com/t5/Talend-Studio/text-file-to-clob/m-p/2247683#M32789 nikhilsh1 2013-10-21T07:41:08Z https://community.qlik.com/t5/Talend-Studio/text-file-to-clob/m-p/2247684#M32790 It can be done this way:<BR />Use the tFileInputDelimited and configure row separator and field separator with values never exists in your file. This way, this component reads the whole file.<BR />Configure the schema to have only one column (e.g. name it content and use String as type).<BR />I guess your target table has a key field? - I would suggest using a key field, your file name looks like a nice key.<BR />tFileInputDelimited ---&gt; tMap (set values for your key field) ----&gt; tOracleOutput<BR />This subjob should be called within a iteration from tFileList.<BR />Now your job reads all files from a directory and stores them in the oracle table.<BR />For this use case in the tOracleOutput I would strongly recommend switch off the batch processing and use 1 as commit size. Mon, 21 Oct 2013 11:25:01 GMT https://community.qlik.com/t5/Talend-Studio/text-file-to-clob/m-p/2247684#M32790 Anonymous 2013-10-21T11:25:01Z