Count rows
ReadHow many rows the vector table holds.
Permissions and limits
Account permissions
- An ORDS REST-enabled schema user (Basic sign-in) with SELECT, INSERT, UPDATE and DELETE on the vector table
Data · CONNECTIONOracle Database (ORDS) + NodeHub
Store and search vectors in an Oracle Database 23ai table through Oracle REST Data Services, with your own embeddings.
Explore 7 workflow actions for Oracle Database (ORDS), including account permissions and operation limits.
4 read actions3 write actions
WORKFLOW ACTIONS
What you can configure.
Choose an action in the workflow builder, connect an account, and map its inputs. These actions are available in the catalog; your account access and a successful test determine whether they work for your setup.
Delete row
WriteDeletes the row with this external ID.
Permissions and limits
Account permissions
- An ORDS REST-enabled schema user (Basic sign-in) with SELECT, INSERT, UPDATE and DELETE on the vector table
Operation limits
- A deleted row cannot be restored.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Get row
ReadOne row's text and metadata by external ID.
Permissions and limits
Account permissions
- An ORDS REST-enabled schema user (Basic sign-in) with SELECT, INSERT, UPDATE and DELETE on the vector table
Insert row
WriteInserts one row with its external ID, your vector, text and metadata.
Permissions and limits
Account permissions
- An ORDS REST-enabled schema user (Basic sign-in) with SELECT, INSERT, UPDATE and DELETE on the vector table
A repeated request may repeat the external action. Review the previous result before retrying a write.
Search nearest rows
ReadThe rows nearest to your vector, with their text, metadata and distance.
Permissions and limits
Account permissions
- An ORDS REST-enabled schema user (Basic sign-in) with SELECT, INSERT, UPDATE and DELETE on the vector table
Search nearest rows with a metadata filter
ReadThe rows nearest to your vector whose metadata key equals a value.
Permissions and limits
Account permissions
- An ORDS REST-enabled schema user (Basic sign-in) with SELECT, INSERT, UPDATE and DELETE on the vector table
Upsert row
WriteUpdates the row with this external ID, or inserts it, with your vector, text and metadata.
Permissions and limits
Account permissions
- An ORDS REST-enabled schema user (Basic sign-in) with SELECT, INSERT, UPDATE and DELETE on the vector table
A repeated request may repeat the external action. Review the previous result before retrying a write.
SETUP
Start with a controlled test.
01Connect the intended account
Use the account and permissions required for your process. Review the connection check before configuring a workflow action.
02Review inputs and access
Select a listed operation and map its required inputs. Use test records and add a human approval before writes that need review.
03Confirm the result
Inspect step outputs and confirm the result in Oracle Database (ORDS). A saved workflow is not a completed provider action.
EXPLORE YOUR STACK
