db-oracle: Oracle database bindings for Node.js

For detailed information about this and other Node.js database bindings visit the Node.js db-mysql homepage.

INSTALL

Before proceeding with installation, you need to have the OCI instant client libraries and include files. In order for the installation script to locate them properly, you’ll need to set the OCI_INCLUDE_DIR and OCI_LIB_DIR environment variables. For example:

$ export OCI_INCLUDE_DIR=/opt/instantclient/sdk/include/

$ export OCI_LIB_DIR=/opt/instantclient

Once the environment variables are set, install with npm:

$ npm install db-oracle

QUICK START

var oracle = require(‘db-oracle’);

new oracle.Database({

hostname: ‘localhost’,

user: ‘root’,

password: ‘password’,

database: ‘node’

}).connect(function(error) {

if (error) {

return console.log(“CONNECTION ERROR: ” + error);

}

this.query().select(‘*’).from(‘users’).execute(function(error, rows) {

if (error) {

return console.log(‘ERROR: ‘ + error);

}

console.log(rows.length + ‘ ROWS’);

});

});

LICENSE

This module is released under the MIT License.

information has been taken from ‘https://github.com/mariano/node-db-oracle’