Stored Procedure (PostgreSQL) activity
An activity that runs a stored procedure in PostgreSQL.

Configure the Stored Procedure activity
Prerequisites
- AgilePoint NX OnDemand (public cloud), or AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v8.0 Software Update 2 or higher.
Good to Know
- To send an email notification, click
Advanced
> Email Notifications
.
For more information, refer to Email Notifications screen (Process Activities).
- In most text fields, you can use process data variables as an alternative to literal data values.
- You can configure whether this activity waits for other activities before it runs.
For more information, refer to How Do I Configure an Activity to Wait for Other Incoming Activities?
- This section shows the configuration settings on the configuration screens for this activity. Other configuration settings apply to system activities. For more information, refer to:
How to Start
- Open Process Builder.
For information about how to open this screen, refer to Process Builder.
- In Process Builder, in the Activity Library,
open the PostgreSQL tab.
- On the PostgreSQL tab,
drag the Stored Procedure
activity onto your process.
General Configuration
Specifies the basic settings for the Stored Procedure activity.

Good to Know
- Documentation for this screen is provided for completeness. The fields are mostly self-explanatory.
Fields
Field Name | Definition |
---|---|
Display Name |
|
Description |
|
Stored Procedure Configuration > Request Parameters
Specifies the input values for the stored procedure that runs in PostgreSQL.

Fields
Field Name | Definition |
---|---|
PostgreSQL |
|
Create |
|
Schema |
|
Stored Procedure Name |
|
Map Request To App Schema |
|
Stored Procedure Configuration > Response Parameters
Maps the response data from PostgreSQL to your process schema.

Fields
Field Name | Definition |
---|---|
PostgreSQL |
|
Create |
|
Schema |
|
Stored Procedure Name |
|
Map Response To App Schema |
|