APIANT.aiApp
Oracle Database
Connect directly to an Oracle database and run SQL statements from your automations. Requires Oracle Database 12.1 or newer: the ready-made row operations (add, find, update and delete a row), the two polling triggers, and the table and column pickers all refuse to run against an older server such as 11g. On 11g only the custom-query operations are available.
What your agent can do with Oracle Database
Triggers and actions 5 triggers · 7 actions
- TriggerNew Column
Fires when a new column appears on an Oracle table you choose.
- TriggerNew or Updated Row
Triggers when a new row is added or modified.
- TriggerNew or Updated Row (Custom Query)
Fires for each new or changed row returned by a SELECT statement you write against the connected Oracle database.
- TriggerNew Row
Triggers when you add a new row.
- TriggerNew Table
Fires when a new table appears in the connected Oracle user's own schema.
- ActionAdd Row
Add one row to a table on the connected Oracle database.
- ActionDelete Row
Delete the rows in a table whose chosen column equals a value.
- ActionFind Row
Find the first row in a table whose chosen column matches a value.
- ActionFind Rows via Custom Query
Runs a SELECT statement you write against the connected Oracle database and returns every row it matches.
- ActionFind Row via Custom Query
Runs a SELECT statement you write against the connected Oracle database and returns the first row it matches.
- ActionRun Custom Statement
Runs a statement you write against the connected Oracle database that changes data rather than returning rows, and reports how many rows it changed.
- ActionUpdate Row
Change column values on every row of a table whose chosen column matches a value.
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.
Not listed?
Need a trigger or action that is not here?
Ask your agent. Describe what you need in plain language and it reads the Oracle Database API documentation, builds the operation at whatever depth the API allows, tests every branch and ships it. The list above is what exists today, not the limit.