Skip to content

Instantly share code, notes, and snippets.

@askldjd askldjd/vacols-with-node.js Secret
Created Feb 23, 2017

Embed
What would you like to do?
var oracledb = require('oracledb');
oracledb.getConnection({
user: "USERNAME",
password: "PASSWORD",
connectString: "HOSTNAME:PORT/DATABASE_NAME"
},
function(err, connection) {
console.log('got connection', err, connection);
setInterval(function() {
if (err) { console.error(err); return; }
connection.execute("SELECT * FROM VACOLS.BRIEFF WHERE BFKEY=TO_CHAR(12345)", function(err, result) {
if (err) { console.error(err); return; }
console.log(result.rows);
});
}, 2000);
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.