Aware_Support,
This would be a great enhancement just as you outlined!
I would not want to bite off more than is necessary right away, but I want to mention a couple of things for you to think about (.... there is no expectation that any of these items will be included now or in the future)
Stored Procedures often have Input Parameters and Output Parameters. It would be great if there was a way, when you called an Action to differentiate between the two. I have two standard outputs for almost all procedures (@o_errcode, @o_errmsg). These provide a return of error or success codes with appropriate messages. It would be great if we could push these to a Display Message (not a big deal, I can push these to a temp table that is persisted within AwareIM as existing table on the table.
Stored Procedures can also return "row sets" - a List or query results grid?
I mostly would use SP Actions in certain Processes, but I can think of instances where I would uses these in BO Rules, Presentations, Reports, Schedules, Imports/Exports.
zero expection!
If you need help testing, let me know. I would be happy to run through a couple dozen scenarios.
