**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
Hi James,
We are using Execute Stored Procedure in Test and Prod region with plug-in version 1.4.2 for both.
In Test, SP seems to be working fine with no error. But in Prod, the exact same SP is failing with GTID error.
GTID is enabled in both regions.
SP have multiple IN and OUT parameters along with creation and deletion of temp table.
Could you please suggest what could be possible reason for Prod failure.
Thanks & Regards,
Nafis Khan
Additionally, I checked the Execute Stored Procedure logs and found that the issue is not consistent. Sometime it works, sometime it don't.
We are using Smart Service.
Appian version 18.4