Oracle Database Component
Query and manage data in an OracleDB database
Component key: oracledb
Description
Oracle Database is a popular relational database system. This component allows you to query an Oracle database.
API Documentation
This component was built using Node.js for Oracle Database
Query formatting
Instead of generating dynamic queries and sanitizing SQL yourself, you can use generic queries with variable binding.
Formatted queries use :variable_name syntax as placeholders for variable values.
For example, your query may read INSERT INTO people (id, first, last) VALUES (:id, :firstname, :lastname) or SELECT firstname, lastname FROM people WHERE id = :id.
If you know your named parameter's names ahead of time, you can provide a Named Parameter input with key id, firstname or lastname, and a value that references a previous step's result.
If you are dynamically generating SQL queries and do not know what parameters you will need ahead of time, create a key/value object in another step and reference them through the Named Parameters Object input.
In the example above, you could generate an object of the form {id: 1, firstname: "John", lastname: "Doe"}.
Connections
OracleDB Connection
On-prem enabled: this connection can be configured to connect to an on-prem resource on a private network. Learn more.
| Input | Notes | Example |
|---|---|---|
| Database | The database SID in Oracle DB | xe |
| Host | Provide the string value for the host of the server. | 192.168.0.1 |
| Password | ||
| Port | The port of the Oracle DB server. | 1521 |
| Connection Timeout | The amount of time (in seconds) to wait for a connection to be established before timing out. Default is 10 seconds. | 10 |
| Username |
Actions
Query
Returns the results of an OracleDB database query | key: query
| Input | Notes | Example |
|---|---|---|
| Connection | ||
| Named Parameters | Optional named parameters to insert into a query. Ensure the keys of these parameters match parameters in your query. For example, if your query contains ':company_name', give this parameter the key 'company_name'. Values specified here are merged with values supplied from the 'Named Parameters Object' input. | |
| Named Parameters Object | Optional named parameters to insert into a query. Ensure the keys of these parameters match parameters in your query. For example, if your query contains ':company_name', your object should contain a key 'company_name'. Values in this object are merged with values supplied from the 'Named Parameters' input. | |
| SQL Query |
Changelog
2025-04-16
Initial release of Oracle Database component for database connectivity and operations