# Oracle - Run custom SQL action
# Run custom SQL
This action lets you send a SQL string to the Oracle database to be executed. It can be used to execute Data Manipulation Language (DML) statements like
DELETE, as well as Data Definition Language (DDL) commands, like
Unlike Select rows using custom SQL, this action is not optimized for easy configuration. For
SELECT statements with large number of columns, use that action instead. Using custom SQL is 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 custom SQL to make your recipes more efficient.
This action requires a connection using OPA version 2.4.3 or newer.
Run custom SQL action
# Input fields
This field is required. Provide a valid SQL string to be executed. This SQL string will be executed in your Oracle database.
If multiple SQL statements are provided, all of them will be executed. However, only results from the last statement will be returned. Make sure each statement is separated by a
You can map datapills here to execute dynamically changing SQL statements. Remember to wrap datapills in quotes (
Use this input to describe the columns that you are expecting from your SQL statement.
If you do not expect any return values or do not need any, you may ignore this input field.
# Output fields
List of rows returned from the SQL execution. The fields in this list are defined by the Output fields input field.
If left blank, this row will be available in the datatree as an array datapill.
This is an integer value indicating the number of rows inserted/updated/deleted from the SQL string.
When executing a DDL (for example, creating a table), the value
There is a size limit of
1000 rows when your custom SQL statement returns data.
# 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
- Execute stored procedure
Or get busy building your recipes now! Check out our