Guest User

Untitled

a guest
Nov 15th, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.56 KB | None | 0 0
  1. module.exports = function(app, db) {
  2. app.post('/newInput', function(req, res) {
  3. var insert = "INSERT INTO KFEDOROV.ISSUES_TABLE VALUES ('"+
  4. req.body.reqNo+
  5. "', '"+
  6. req.body.entity+
  7. "', '"+
  8. req.body.userId+
  9. "', '"+
  10. req.body.newValue+
  11. "', '"+
  12. req.body.userId+
  13. "', '"+
  14. req.body.userOrgUai+
  15. "', 'NEW','"+
  16. req.body.oldValue+
  17. "');";
  18.  
  19.  
  20. oracledb.getConnection(
  21. {
  22. user: 'user',
  23. password: 'pass',
  24. connectString: 'connection'
  25. },
  26. function (err, connection) {
  27. if (err) {
  28. console.error(err.message);
  29. return;
  30. }
  31. connection.execute(insert, { autoCommit: true}, function(err, result) {
  32. if (err) {
  33. console.error(err.message);
  34. doRelease(connection);
  35. return;
  36. } else {
  37. console.log(result.rows);
  38. doRelease(connection);
  39. }
  40. }
  41. )
  42.  
  43.  
  44. function doRelease(connection)
  45. {
  46. connection.close(
  47. function(err) {
  48. if (err)
  49. console.error(err.message);
  50. });
  51. }
  52. });
  53. });
  54.  
  55. execute(String sql, [Object bindParams, [Object options,]] function(Error error, [Object result]){});
  56.  
  57. connection.execute(insert, [], { autoCommit: true}, function(err, result) {
  58. ...
Add Comment
Please, Sign In to add comment