Information
  • Author: Appian Corporation
  • Type: Plug-in (Function & Smart Service)
  • Support: This plug-in or utility is not supported by the author. The content is free to use with a licensed product, but it is made available as-is and Community supported.
  • Industry: All Industries
  • Compatible Version(s): 18.4+
  • First Released:
  • Last Updated:
  • Cost: Free
Resources
Share
Home » AppMarket » Execute Stored Procedure

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

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:

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

Key Features & 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
Anonymous
Parents

  • Hi,

    We upgraded Appian to version 20.4 recently and during this process, we also upgraded this plugin from v1.4.4 to v1.5.3. Following the upgrade, one of our processes that uses the Execute Stored Procedure smart-service ran as scheduled. The process takes a file with ~45k rows, splits it into batches of 1000, and then runs the smart service for each batch.

    We are seeing that the first 10 or so batches are taking an hour each to run, and then suddenly the batches start completing in 5 minutes each.

    Prior to the upgrade, each batch would complete in ~5 minutes. The smart-service slowdown/hanging is only happening between 1am and 8am which is really strange. 

    Any thoughts on whether or not this could be a plugin issue? Has anyone seen any similar behaviour?

Comment

  • Hi,

    We upgraded Appian to version 20.4 recently and during this process, we also upgraded this plugin from v1.4.4 to v1.5.3. Following the upgrade, one of our processes that uses the Execute Stored Procedure smart-service ran as scheduled. The process takes a file with ~45k rows, splits it into batches of 1000, and then runs the smart service for each batch.

    We are seeing that the first 10 or so batches are taking an hour each to run, and then suddenly the batches start completing in 5 minutes each.

    Prior to the upgrade, each batch would complete in ~5 minutes. The smart-service slowdown/hanging is only happening between 1am and 8am which is really strange. 

    Any thoughts on whether or not this could be a plugin issue? Has anyone seen any similar behaviour?

Children
No Data

© 2024 Appian. All rights reserved.