Support Questions

Find answers, ask questions, and share your expertise
Announcements
We’ve updated our product names and community labels - click here for full details

executeSql bind query

avatar
Explorer

How can I send select queries to the Oracle database to be binded with the executeSql processor in Apache NiFi 1.23.2 version?

1 REPLY 1

avatar
Master Collaborator

Hello @hus

Directly the ExecuteSQL processor does not support binding. 
The input should be directly SQL query. 
https://nifi.apache.org/components/org.apache.nifi.processors.standard.ExecuteSQL/

But, according to the API docs, the processor can be started via a FlowFile: 
https://javadoc.io/static/org.apache.nifi/nifi-standard-processors/2.4.0/org/apache/nifi/processors/...
So technically you should be able to start this query by using ReplaceText to inject values dynamically, for example. 


Regards,
Andrés Fallas
--
Was your question answered? Please take some time to click on "Accept as Solution" below this post.
If you find a reply useful, say thanks by clicking on the thumbs-up button.