Support Questions
Find answers, ask questions, and share your expertise

How to call oracle Store procedure in Apache NiFi

Explorer

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.

1 ACCEPTED SOLUTION

Rising Star

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 

 

 

View solution in original post

2 REPLIES 2

Explorer

Hi All, Can you please help me. 

Rising Star

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 

 

 

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.