Calling Stored Procedure using Knime

Question

I tried calling a stored procedure using DatabaseReader node but it does not worked for me.

Can anyone suggest me how I can call a stored procedure in Knime?

Thanks, Krishna

Answer 1

by setting the option "Run SQL Query only during execute, skips configure" on configure dialog. we can execute SP using database reader node.

thanks, Krishna