Connect to a Oracle Database

Connect to a Oracle database and run dynamic scripts through that library. The library is responsible for connecting to the database, executing the script and closing the connection after execution.

const oracle = require('linkapi-sdk/state/oracledb');

const config = {
  credentials: {
    "user": "",
    "password": "",
    "host": "",
    "port": "",
    "servicename": "",
  }
}

const options = {
  rawResult: false // result is returned with no parse
};

const query = 'SELECT * FROM {{table}}';

const queryValues = {
  table: 'PRODUCTS'
};

const result = await oracle.execute(config, options);