**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
Hello, we are trying to use the Data Generation Application, however we ran into an issue when the application attempts to call one of the stored procedures as part of the Data Generation process. It occurs in the DG_RetrieveTablesForApplication expression rule, while calling the executestoredprocedure() function inside of the "Execute Stored Procedure" plugin. However we keep getting this error:
We are passing in the parameters for the stored procedure using the ProcedureInput CDT. Currently we are using MySql version 8.0.20, and the stored procedure seems to work fine when we execute it from the DB itself.
Could you help to look into this issue? Thanks.