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

I am Trying to invoke a (mysql)stored procedure in nifi. How can i do it ?

New Contributor
 
2 REPLIES 2

Super Mentor

@Shivani Mishra

One option will be to write the exec StoredProcedure into a shell script or groovy and run it in ExecuteProcess/ExecuteScript?

Something as described in the following HCC Thread:

https://community.hortonworks.com/questions/26170/does-executesql-processor-allow-to-execute-stored....

Super Guru

Also, depending on what your stored procedure looks like, you may be able to use ExecuteSQL or PutSQL. However they do not support setting output parameters, and I'm not sure if they support input parameters. But if your procedure is hard-coded, then if it returns a ResultSet then ExecuteSQL should work, and if it doesn't, then PutSQL should work. Otherwise the above answer is the best bet.