Supported actions
Triggers
Prerequisites
- An Oracle Database instance reachable from the platform runtime.
- An Oracle database username and password with permissions for the tables and SQL operations used by your tools or workflows.
- The database host, listener port, and service name, or a full connection string.
Set up the integration
1
Create an Oracle Database auth profile
In Integrations, select Oracle Database > Connect. On Project Auth Profiles, select New Profile > Integration Profile > Oracle Database > Continue. Keep API Key as the auth type. Enter a profile name and database connection details. Port defaults to
1521. Provide a Service Name with the host and port, or provide a Connection String instead. Enter the database Username and password in API Key, then select Create Profile.2
Create an action tool
In Tools, select New Tool > Action Tool > Oracle Database. Select an action and auth profile, configure its inputs, and select Create Tool. Then assign the tool to an agent.
3
Use the New Row trigger (optional)
In a workflow, select Oracle Database > New Row as the trigger. Choose a table and an order column that increases over time, such as an ID or timestamp.
Action reference
Insert Row
Insert Row
Insert Rows
Insert Rows
Run Custom SQL
Run Custom SQL
For SELECT/WITH queries, use an
ORDER BY clause to keep pages stable. Results include rows, rowCount, offset, limit, hasMore, and nextOffset. When hasMore is true, pass nextOffset to the next call. Other statements return at most 500 rows.Security: Don’t insert dynamic input directly into the SQL string. Use bind parameters to help prevent SQL injection.Update Row
Update Row
Delete Row
Delete Row
Find Row
Find Row
The action returns at most
500 rows and sets hasMore when additional rows match. Use Run Custom SQL to page through larger result sets.Trigger reference
New Row
New Row