Oracle Database Connector
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
Connections
OracleDB Connection
Authenticate requests to an OracleDB server.
| Input | Comments | Default |
|---|---|---|
| Host | Provide the string value for the host of the server. | |
| Port | The port of the Oracle DB server. | 1521 |
| Database | The database SID in Oracle DB | |
| Username | ||
| Password | ||
| Connection Timeout | The amount of time (in seconds) to wait for a connection to be established before timing out. Default is 10 seconds. | 10 |
Actions
Query
Returns the results of an OracleDB database query
| Input | Comments | Default |
|---|---|---|
| Connection | ||
| SQL Query | SELECT * FROM mytable WHERE name = :name AND company = :company_id | |
| 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. |