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	Default	Notes	Example
Database string / Required database		The database SID in Oracle DB	xe
Host string / Required host		Provide the string value for the host of the server.	192.168.0.1
Password password password
Port string / Required port	1521	The port of the Oracle DB server.
Connection Timeout string timeout	10	The amount of time (in seconds) to wait for a connection to be established before timing out. Default is 10 seconds.
Username string username

Actions

Query

Returns the results of an OracleDB database query | key: query

Input	Default	Notes	Example
Connection connection / Required connection
Named Parameters string Key Value List namedParameters		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 code namedParametersObject		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 code / Required query

---