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.
Asked
Active
Viewed 349 times
0
-
Have a look at this - https://community.cloudera.com/t5/Support-Questions/Execute-Stored-Procedure-of-MSSQL-in-Nifi/td-p/213365 – Vikramsinh Shinde Jun 22 '22 at 05:30
-
this solution is not working for me – Jun 22 '22 at 07:13
-
what do you mean by `not working` - are you getting any exceptions or failures at any other place? – Vikramsinh Shinde Jun 22 '22 at 12:11
-
its saying invalid SQL statement – Jun 22 '22 at 12:16
-
Are you using any statement terminator like `;`? Is it possible to provide SQL statement? – Vikramsinh Shinde Jun 23 '22 at 15:04
-
found the solution. thanks – Jun 24 '22 at 06:53
-
Please add your solution as the answer, it might be helpful for someone, thanks! – Vikramsinh Shinde Jun 25 '22 at 03:28
-
http://funnifi.blogspot.com/2016/04/sql-in-nifi-with-executescript.html --> solution is given in this link. Please refer – Jun 25 '22 at 11:23