Oracle - Execute stored procedure action
Execute stored procedure
This action lets you execute any stored procedure or functions saved in your database instance. To use this action, your Oracle connection must be established using an On-premise agent. Stored procedures from packages are not supported in this action.
Execute stored procedure rows action
First, select a stored procedure to execute. This can be done either by selecting from the pick list, or toggling the input to text mode and providing the full stored procedure name.
Next, provide any input parameters required for the selected stored procedure.
Datasets returned from stored procedures in Oracle are not returned in this action.