**NOTE: This plug-in is deprecated and no longer recommended for use for sites running on Appian 22.1 or later. The functionality of this component is available in Appian without installing the plug-in. You can use a!executeStoredProcedureForQuery(), a!executeStoredProcedureOnSave(), or the Execute Stored Procedure Smart Service in Appian 22.1 or later.**
Overview
This plug-in provides a Smart Service and Function for executing stored procedures. The Smart Service can be used to execute stored procedures that modify data. Result sets are returned as CDTs. As custom functions cannot have side-effects, it must not be used to execute stored procedures that modify data. It is only safe to use the Smart Service with stored procedures that modify data. Following SQL Statements should not be used by the stored procedures executed with the function:
Key Features & Functionality
I see that the latest version of the executestoredprocedure now has the Timeout parameter.And it defaults to 30 seconds. Would you be able to let us know what would be the default timeout for previous versions of the function? This is imporatant as I have seen some of the cases where we used executestoredprocedure (prior to this update) take more than 30 seconds and Im concerned about any issues in existing code due to this plugin update.
Also, does the Timeout actually kill the query or only disconnects the Application from the DB? It would be very useful if the query can be killed so the potentially long running query doesn't affect the DB.
And also, the timeout for the Execute Stored Procedure Smart Service (which doesn't yet have this option). Is there a plan to include the Timeout parameter in the smart service in future versions?
Thank you for this wonderful and very useful plugin,
Pavan