**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
@ajinkyab277 are you using version 1.4.6? (if not, please upgrade and try again). If that does not help, try to set auto commit at the beginning of the stored procedure
dev.mysql.com/.../replication-gtids-restrictions.html - "It is possible to use these statements with GTIDs enabled, but only outside of any transaction, and only with autocommit=1."
The function initiates an explicit transactions and must not be used in conjunction with statements that modify data (such as temporary tables, insert, update, delete, etc statements). SELECT statements are safe to use with the function.
The smart service does not initiate an explicit transactions, as as long as v1.4.6 is deployed and possibly also autocommit=1 is enabled in the stored procedure it should work