Silver ⭐️⭐️⭐️

Solved

How to call oracle Store procedure in Apache NiFi

3 replies
4276 views
Translate All

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.

Apache NiFi

ckumarAnswer

Platinum ⭐️

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-processor-with-both-in-and

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

Techie123Author

Silver ⭐️⭐️⭐️

Hi All, Can you please help me.

Translate

ckumarAnswer

Platinum ⭐️

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-processor-with-both-in-and

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

Translate

Gold ⭐️

Hello, you can see other solution here:

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

Translate