To run the examples:

- [Install node-oracledb](https://oracle.github.io/node-oracledb/INSTALL.html#quickstart).

```

```

- Review the samples and then run them like:

[`dbmsoutputpipe.js`](dbmsoutputpipe.js) | Show fetching DBMS_OUTPUT by using a pipelined table

[`demodrop.js`](demodrop.js) | Drops the schema objects created by the examples

[`demosetup.js`](demosetup.js) | Used to create common schema objects for the examples

[`em_batcherrors.js`](em_batcherrors.js) | `executeMany()` example showing handling data errors

[`em_dmlreturn1.js`](em_dmlreturn1.js) | `executeMany()` example of DML RETURNING that returns single values

[`em_dmlreturn2.js`](em_dmlreturn2.js) | `executeMany()` example of DML RETURNING that returns multiple values

[`impres.js`](impres.js) | Shows PL/SQL 'Implict Results' returning multiple query results from PL/SQL code.

[`insert1.js`](insert1.js) | Basic example creating a table and inserting data. Shows DDL and DML

[`insert2.js`](insert2.js) | Basic example showing auto commit behavior

[`lobbinds.js`](lobbinds.js) | Demonstrates how to bind and query LOBs

[`lobinsert1.js`](lobinsert1.js) | Shows inserting a file into a CLOB column

[`lobinsert2.js`](lobinsert2.js) | Inserts text into a CLOB column using the RETURNING INTO method.

[`select1.js`](select1.js) | Executes a basic query without using a connection pool or ResultSet

[`select2.js`](select2.js) | Executes queries to show array and object output formats

[`selectgeometry.js`](selectgeometry.js) | Insert and query Oracle Spatial geometries

[`selectjsonblob.js`](selectjsonblob.js) | Shows how to use a BLOB as a JSON column store

[`selectobject.js`](selectobject.js) | Insert and query a named Oracle database object

[`selectnestedcursor.js`](selectnestedcursor.js) | Shows selecting from a nested cursor

[`sessiontagging2.js`](sessiontagging2.js) | More complex example of pooled connection tagging for setting session state

[`soda1.js`](soda1.js) | Basic Simple Oracle Document Access (SODA) example

[`version.js`](version.js) | Shows the node-oracledb version attributes

const oracledb = require('oracledb');

const dbConfig = require('./dbconfig.js');

const queueName = "DEMO_RAW_QUEUE";

async function enq() {

const oracledb = require('oracledb');

const dbConfig = require('./dbconfig.js');

const queueName = "ADDR_QUEUE";

async function enq() {

const oracledb = require('oracledb');

const dbConfig = require('./dbconfig.js');

const queueName = "DEMO_RAW_QUEUE";

async function enq() {

const oracledb = require('oracledb');

const dbConfig = require('./dbconfig.js');

const queueName = "DEMO_RAW_QUEUE";

async function enq() {

const dbConfig = require('./dbconfig.js');

const demoSetup = require('./demosetup.js');

const httpPort = 7000;

await oracledb.getPool().close(2);

console.log('Pool closed');

process.exit(0);

console.error(err.message);

process.exit(1);

}

const oracledb = require("oracledb");

const dbConfig = require('./dbconfig.js');

const dboptime = 4; // seconds the simulated database operation will take

const timeout = 2; // seconds the application will wait for the database operation

const oracledb = require('oracledb');

const dbConfig = require('./dbconfig.js');

async function run() {

let connection;

const oracledb = require('oracledb');

const dbConfig = require('./dbconfig.js');

async function init() {

try {

// Create a connection pool which will later be accessed via the

// queueMax: 500, // don't allow more than 500 unsatisfied getConnection() calls in the pool queue

// queueTimeout: 60000, // terminate getConnection() calls queued for longer than 60000 milliseconds

// sessionCallback: myFunction, // function invoked for brand new connections or by a connection tag mismatch

// stmtCacheSize: 30, // number of statements that are cached in the statement cache of each connection

});

console.log('Connection pool started');

const options = { outFormat: oracledb.OUT_FORMAT_OBJECT };

const result = await connection.execute(sql, binds, options);

console.log(result);

} catch (err) {

console.error(err);

} finally {

await oracledb.getPool().close(10);

console.log('Pool closed');

process.exit(0);

console.error(err.message);

process.exit(1);

}

const oracledb = require("oracledb");

const dbConfig = require('./dbconfig.js');

dbConfig.events = true; // CQN needs events mode

const interval = setInterval(function() {

console.log("waiting...");

}, 5000);

// message.type is one of the oracledb.SUBSCR_EVENT_TYPE_* values

console.log("Message type:", message.type);

if (message.type == oracledb.SUBSCR_EVENT_TYPE_DEREG) {

for (const s of stmts) {

try {

await connection.execute(s);

if (e.errorNum != 942)

console.error(e);

}