Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- module.exports = function(app, db) {
- app.post('/newInput', function(req, res) {
- var insert = "INSERT INTO KFEDOROV.ISSUES_TABLE VALUES ('"+
- req.body.reqNo+
- "', '"+
- req.body.entity+
- "', '"+
- req.body.userId+
- "', '"+
- req.body.newValue+
- "', '"+
- req.body.userId+
- "', '"+
- req.body.userOrgUai+
- "', 'NEW','"+
- req.body.oldValue+
- "');";
- oracledb.getConnection(
- {
- user: 'user',
- password: 'pass',
- connectString: 'connection'
- },
- function (err, connection) {
- if (err) {
- console.error(err.message);
- return;
- }
- connection.execute(insert, { autoCommit: true}, function(err, result) {
- if (err) {
- console.error(err.message);
- doRelease(connection);
- return;
- } else {
- console.log(result.rows);
- doRelease(connection);
- }
- }
- )
- function doRelease(connection)
- {
- connection.close(
- function(err) {
- if (err)
- console.error(err.message);
- });
- }
- });
- });
- execute(String sql, [Object bindParams, [Object options,]] function(Error error, [Object result]){});
- connection.execute(insert, [], { autoCommit: true}, function(err, result) {
- ...
Add Comment
Please, Sign In to add comment