# 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. They can be written to accept input parameters and perform actions on these input parameters. Workato's
Execute stored procedure action is able to pick up on parameter inputs and allows you to dynamically input these parameters directly from your workflow.
Using stored procedures are a great way to improve recipe efficiency and balance load between Workato and your database. Find out more in our best practices section how to use stored procedures to make your recipes more efficient.
Execute stored procedure rows action
# Stored procedure
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. When working with overloaded stored procedures, you will see multiple stored procedures with its
sub_program_id in brackets next to each.
Each overloaded stored procedure will show up with its sub_program_id in brackets next to the name
To find out the different sub_program_ids for an overloaded stored procedure, use the following query in your DBMS.
SELECT position, argument_name, in_out, data_type, data_length, data_precision, data_scale, char_length, object_name, subprogram_id FROM SYS.ALL_ARGUMENTS where object_name = [stored_procedure_name]
[stored_procedure_name] is the name of the overloaded stored procedure.
# Input parameters
Next, provide any input parameters required for the selected stored procedure.
Datasets returned from stored procedures in Oracle are not returned in this action.
# List of Workato triggers and actions
Workato currently supports the following triggers and actions. Find out more details about each by clicking on the links below. You can also navigate to them through the side bar.
- New row trigger
- New/updated row trigger
- Select actions
- Insert actions
- Update actions
- Upsert actions
- Delete actions
- Run custom SQL action
Or get busy building your recipes now! Check out our