Execute Stored Procedure

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.

  • 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
  • Total row count column added to trace log

For Appian Cloud customers please note that Appian Cloud enforces GTID consistency. To ensure this Smart Service is read-only, any Cloud-based stored procedures that create temporary tables cannot be used in conjunction with this Plug-in

v1.5.1 now has configurable timeout (default 30 seconds)

Anonymous