Skip to main content

Is it possible with the Database: Run stored procedure command to capture the output from theSQL command.

 

I have a SP that performs a SQL Update to a table, and wondering if it is possible to capture the output of the SP to confirm the record was updated.

Hi @AndyF ,

 

There is an option Export Data to CSV in the Database:Read action where you can see the result from an SQL read query. But unfortunately, there is nothing like that for Insert/Update/Delete action.


@AndyF 

Maybe you can create a table with a single record to save the output from your SP adding an extra insert on it. 

 

HTH

Regards


Reply