**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, which plugin version is executestoredprocedureforked() available on?
The plugin does not support PG. Appian will be supporting execution of stored procedures and will add PG support in the very near future.
Hi,
We are trying to use executestoredprocedure for a procedure written in SQL server. The procedure takes 2 parameters of type 'bigint' and executes succefully within database client but it fails to execute stating 'cannot convert nvarchar to bigint'.
Any idea how to bypass this issue?
Looks like plugins are not yet supported as per documentation:
https://docs.appian.com/suite/help/21.4/data-source-connected-systems.html#for-plug-ins-that-connect-to-data-sources,-use-the-administration-console
How to fetch the result from a ref cursor through a stored procedure using the Execute Stored Procedure node ?
After verification, It is not exactly the same issue and seem lower but exist https://www.cvedetails.com/cve/CVE-2019-17571/
Seem not true: Take a look on https://logging.apache.org/log4j/1.2/
I have received confirmation from Appian support that only Log4J 2.x is affected by this. Since this plug-in uses only 1.2.17, it would not require an update.
I have a client using this plugin and would require this update as soon as possible.
Hi It appears that this plugin references Log4J 1.2.17 within the typetransformer 1.2.jar plugin. Can you please release an updated version of the plugin to counter the vulnerability exposed by - CVE-2021-44228 ?