Advertisement
Guest User

Untitled

a guest
Mar 17th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. var oracledb = require('oracledb');
  2.  
  3. //replace connectString as appropriate
  4. var connectionInfo = {
  5. user: 'nodetest',
  6. password: 'nodetest',
  7. connectString: ""
  8. }
  9.  
  10. //arbitrarily large to help trigger this
  11. var runs = 400;
  12.  
  13. let runIt = (theNumber) => oracledb.getConnection(connectionInfo,
  14. function(error, connection) {
  15. if (error) return;
  16. else {
  17. var sql = 'BEGIN testNumericOutBinds(:numberIn, :numberOut); END;'
  18. var params = {
  19. numberIn: theNumber,
  20. numberOut: {
  21. type: oracledb.NUMBER,
  22. dir: oracledb.BIND_OUT
  23. }
  24. }
  25.  
  26. connection.execute(sql, params, function(err, result) {
  27. if (err) {
  28. console.log('tried number ' + theNumber, err)
  29. }
  30. console.log(result);
  31. connection.close(function(err, a){})
  32.  
  33. });
  34. }
  35. });
  36.  
  37. for(var theNumber = 0; theNumber < runs; theNumber++) {
  38. runIt(theNumber);
  39. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement