question How to call oracle Store procedure in Apache NiFi in Support Questions

How to call oracle Store procedure in Apache NiFi

Techie123 — Tue, 21 Jun 2022 08:50:00 GMT

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.

Re: How to call oracle Store procedure in Apache NiFi

Techie123 — Tue, 21 Jun 2022 10:20:36 GMT

Hi All, Can you please help me.

Re: How to call oracle Store procedure in Apache NiFi

ckumar — Tue, 21 Jun 2022 15:22:50 GMT

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

Re: How to call oracle Store procedure in Apache NiFi

gdr — Wed, 06 Nov 2024 13:31:07 GMT

Hello, you can see other solution here:

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