Execute Stored Procedure

**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.**

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:

INSERT
UPDATE
DELETE
TRUNCATE
CREATE TEMPORARY TABLE
SELECT... INTO (when the input target is not an input or output variable)

Features and Functionality

Works with both complex and simple data types
Tested with: MySQL, SQL Server, and Oracle
See the instructions document provided with the download for an example and how to configure
(New) Total row count column added to trace log

jraquino 2 months ago in reply to Appian AppMarket

Hi, may we know the details of the Oracle cursor bug that this release is fixing?

Thank you
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 2 months ago
v1.5.7 Release Notes
- Bug fix for Oracle cursors
- Cancel
- Up -1 Down
- Reply
- More
- Cancel
Jamie Loizou 3 months ago in reply to mernag0002

Output the cursor, and reference the name of the output parameter in your smart service or function.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
pavan.sastry 3 months ago

@Appian team. would like to know how the new Appian smart service is different from this one. We tested it and found that the timeout is still not being executed by the Database due to an error and the performance is no different. It makes sense ofcourse to have this as a default component given IDP is dependent on this and it is a critical component with many use cases
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 3 months ago
v1.5.6 Release Notes
- Deprecation notice
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket 5 months ago
Release Notes v1.5.5
- Fix for multi-part sql server stored procedure identifiers and CVE fixes.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
bhavikav 5 months ago in reply to Fredlcl

Hi, which plugin version is executestoredprocedureforked() available on?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Julian Bui 6 months ago in reply to vinayakp

The plugin does not support PG. Appian will be supporting execution of stored procedures and will add PG support in the very near future.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
TJ 6 months ago

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?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
jraquino 6 months ago in reply to TJ

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
- Cancel
- Up 0 Down
- Reply
- More
- Cancel