**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 phorning
reading Migration to MariaDB guidelines, I've read that this plugin has some problems with procedures that modify database (insert, delete, update etc..). Is this true? In the application we developed for our main customers we use procedures for this purpose, is this a problem? Is it only related to functions or even to smart services?
Thanks in advance
Best Regards
Stefano
Hi Juergen! Yes this works with Appian Cloud and MariaDB
This plug in has a cloud badge. So - will work with the Appian Cloud database - MariaDB?
community.appian.com/.../executing-stored-procedure-takes-longer-when-called-via-executestoredprocedure-function
community.appian.com/.../execute-stored-procedure---inconsistencies-with-function-smart-service-across-architectures
The plug-in doesn't target a specific version of Oracle however it has been tested with various versions of Oracle since its first release. I would expect this combination to work just fine. You may refer to the Compatible Versions section on the right for Appian version support
does this plugin support Appian 20.2 and Oracle 19.2 version?
Each execution of the smart service or function requests a connection from the pool and returns it to the pool when complete. A high volume of concurrent connections (using this plug-in or other database related functionality in Appian) may result in additional connections being made to the database.
The connection pool behaviour is not specific to this plug-in. If you require further input please reach out to Appian Technical Support.