Skip to main content
Back to list of enterprise systems Use the Oracle Database integration to insert, update, find, and delete rows, run custom SQL or PL/SQL, and trigger workflows when new rows are created.

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

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.
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

Troubleshoot common issues