**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
This plugin itself does not, however, there are one or more memory limits in place in AE that would force execution to fail if the result set and its conversion consumes too much memory.
Does the function executestoredprocedure() have any limitation on how much data it can bring back?
PG Support is found in the out of the box version of execute stored procedure (i.e., not the plugin) that comes packaged with appian
Is this the smart service or the function? The smart service does not have a timeout parameter, from what I can tell from the pdf documentation that comes with the download. Only the function does.
if using a OUT SYS_REFCURSOR as a parameter, the plugin would fail saying "Invalid column type"
Can you verify that this is the execute stored procedure PLUGIN behavior as opposed to the out-of-the-box execute stored procedure? The plugin's smart service uses auto commit true so any finished statement should not get rolled back.
Could you please elaborate on the timeout limitations and data size limitations?
The out of the box version of Execute Stored Procedure packaged with Appian does support postgresql, but this community plugin does not. Do note that this plugin has been deprecated
I am facing above error with execute stored procedure.
After time out queries are not getting cancelled due to which CPU usage is increasing. Could anyone help me why this is happening
Thanks!