The setup in your screenshot looks fine at the surface level and it should run whenever the source field/value changes.

As long as the value you're using as the input parameter is valid, your column names match the output values, and the account under which it is running has sufficient permissions, it should work.

I think the first step is to execute your stored procedure outside of Laserfiche to make sure it is behaving as intended and outputting the expected columns/values.

Something else worth noting is that unlike queries on tables and views, more than read-only access is required in SQL to execute stored procedures.