Does ExecuteSQL processor allow to execute stored procedure ?

[#1]

Can I execute stored procedure on database using ExecuteSQL proessor ? Is there any sample ?

[#2 · Accepted solution]

I don't think so but maybe you can wrap the exec storedprocedure into a shell script or groovy and run it in ExecuteProcess/ExecuteScript?

[#3]

Thank You @Artem Ervits for your suggestion. I was able to call my stored proc using sqlplus and ExecuteProcess processor. Amazing community !

[#4]

Please post a screenshot, it's a great question.

[#5]

@Artem Ervits My database is Oracle, so I used sqlplus to execute a script. Where script has following content.

execute spname(param)
exit

I used ExecuteProcess processor to call sqlplus

Note: This approach assumes that client tools for database are installed on NiFi Server.

[#6]

awesome!!!

[#7]

@Shishir Saxena check this out, you inspired this http://funnifi.blogspot.com/2016/04/sql-in-nifi-with-executescript.html

[#8]

It was really helpful. I used the same method to run a stored procedure on MSSQL using SQLCMD :

SQLCMD  -S server_name -U user_name -P password -i sample.sql

and in sample.sql I put:

exec sp_name sp_parameters

Then I used ExecuteProcess to call SQLCMD along with its parameters.

[#9]

Yes, you can.

Checking the source code, if you set "true" for generate key in "putSql", it will use executeUpdates rather than executeBatch(). It works if you don't need any output from your SP

[#10]

I have tried calling mysql sp with putsql processor.Its worked for me.
my so doesn't return any values only does some insert operations.
thanks @Yilin Han