How to call oracle Store procedure in Apache NiFi

[#1]

I need to use ORACLE stored procedure with input PARAM and this input PARAM is coming from flow file and get output from that stored procedure. is any processor is available with run stored procedure and return the out put in AVRO schema or any other format? Please help me.

[#2]

Hi All, Can you please help me. 

[#3 · Accepted solution]

There is no inbuilt one but you can please refer suggestion posted by one of NiFi Engineers about running Stored procedure  at  https://stackoverflow.com/questions/36306764/how-to-use-procedure-call-in-apache-nifi-executesql-pro...

If you found this response assisted with your issue, please take a moment to login and click on "Accept as Solution" below this post.

Thank you,

Chandan 

[#4]

Hello, you can see other solution here:

https://community.cloudera.com/t5/Support-Questions/Nifi-Execute-Groovy-Script/m-p/344265#M234128