**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
James,
We received the following error when trying to deploy the latest version in Appian 18.2. Any help is appreciated.
12:56:31,720 INFO [stdout] (Appian Plugin Hot Deploy) 2018-08-02 12:56:31,720 [Appian Plugin Hot Deploy] ERROR com.atlassian.plugin.manager.DefaultPluginManager - There was an error loading the descriptor 'ProcedureInput' of plugin 'executestoredprocedure'. Disabling.
12:56:31,724 INFO [stdout] (Appian Plugin Hot Deploy) com.atlassian.plugin.PluginException: com.appiancorp.suiteapi.common.exceptions.AppianException: com.appiancorp.suiteapi.common.exceptions.AppianException: The type [{urn:appian:plugin:executestoredprocedure:types}ProcedureInput] was not exported because of the following error while accessing the Appian data source: [com.appiancorp.type.model.DatatypeModelNotFoundException: Type definitions could not be found in the Appian data source for the following type ids: 5331 (APNX-1-4047-008)]. (APNX-1-4047-00A)