Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to call oracle Store procedure in Apache NiFi

avatar
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

avatar
Master Collaborator

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

avatar
Explorer

Hi All, Can you please help me. 

avatar
Master Collaborator

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