node-red-contrib-easy-oracle

Allows basic access to Oracle databases.

This node uses the query operation against the configured database. Currently supports SELECT operations.

msg.topic of previous node must hold the query for the database, and the result is returned in msg.payload.

msg.payload will contain an object with two keys, metaData and rows. Rows key is an array of values.

If nothing is found for the query, an object with an empty rows array will be returned.

Note: this package depends on node-oracledb so it depends on the Oracle Instant Client that needs to be installed as a prerequisite. Details of installation here and specifically for Linux, using zip file, here.

============

Supports now setting the connection in a previous node using msg.connection object i.e.

msg.connection = {
    user: 'lorem',
    password: 'ipsum',
    host: 'localhost',
    port: 1521,
    database: 'orclpdb1.localdomain'
}

Note: in order to push credentials via msg.connection, it is required to create a dummy database config in the database node (temporary solution, dependency will be removed in the future).