About lokesh87g

lokesh87g · ‎05-02-2019

Hi Matt, I am not sure how to create the flow. In my case i have .xml files downloaded from http request and these files need to be uploaded into a clob column in oracle. I tried to define the sql.args.1.type as 2005 still no luck. can you share any example where we can upload huge flow file content into clob types.

lokesh87g · ‎05-02-2019

Hi Matt, I am new to nifi and i have similar usecase where i want to insert entire flow file content as clob value it throws error when i just use replace text and putSQL processors and i don't have any idea on how to handle it using putDatabaseRecord. Can you provide any example on this one.

lokesh87g · ‎04-25-2019

Hi, Can someone share their idea on how to load complete flow file content into a table having clob datatype. I have tried to achieve this using invokehttp->evaluatexpath->updateattribute->replacetext->putSQL. But it throws an exception with string literal too long. If flow file content is less than 4000 then it works fine but if it is of huge file then it throws error. I am downloading couple of files from rest service and want to load them into a table with clob column.

Online	Offline
Last Visited	‎05-24-2019 07:28 AM

Member Since	‎04-25-2019 11:24 AM
Last Visited	‎05-24-2019 07:28 AM
Posts	5
Kudos received	1

Cloudera Community

Re: load flowfile content into clob datatype using...

Re: Nifi Processor : Insert data into CLOB column

load flowfile content into clob datatype using put...