{"action":"created","issue":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/322","labels_url":"https://api.github.com/repos/oracle/node-oracledb/issues/322/labels{/name}","comments_url":"https://api.github.com/repos/oracle/node-oracledb/issues/322/comments","events_url":"https://api.github.com/repos/oracle/node-oracledb/issues/322/events","html_url":"https://github.com/oracle/node-oracledb/issues/322","id":126362015,"number":322,"title":"Error: ORA-01426: numeric overflow","user":{"login":"sreenivasulun","id":12527084,"avatar_url":"https://avatars.githubusercontent.com/u/12527084?v=3","gravatar_id":"","url":"https://api.github.com/users/sreenivasulun","html_url":"https://github.com/sreenivasulun","followers_url":"https://api.github.com/users/sreenivasulun/followers","following_url":"https://api.github.com/users/sreenivasulun/following{/other_user}","gists_url":"https://api.github.com/users/sreenivasulun/gists{/gist_id}","starred_url":"https://api.github.com/users/sreenivasulun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sreenivasulun/subscriptions","organizations_url":"https://api.github.com/users/sreenivasulun/orgs","repos_url":"https://api.github.com/users/sreenivasulun/repos","events_url":"https://api.github.com/users/sreenivasulun/events{/privacy}","received_events_url":"https://api.github.com/users/sreenivasulun/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/oracle/node-oracledb/labels/question","name":"question","color":"cc317c"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2016-01-13T07:45:32Z","updated_at":"2016-01-21T11:04:34Z","closed_at":"2016-01-18T12:49:50Z","body":"I am getting the following error, when I made a call to pl/sql procedure, \r\nError: ORA-01426: numeric overflow\r\n    at Error (native)\r\n\r\nas follows my code snippet,\r\n'''\r\n  var sqlQuery = \"BEGIN oe_web_txns.pre_web_SaleTrx(:source,:merchantID,:deviceID,:UMI,:dbConverter,\"+\r\n      \":trxTime, :origPA,:initialTrxId,:entityId,:postableAmount,:redemptionType,:adjustedAmount,:xlsTrxId,:errorCode,:errorDescription); END;\";\r\n  \r\n  var bindvars = {\r\n      source:  saleObject.source,  \r\n      merchantID:  saleObject.merchantID,  \r\n      deviceID:  saleObject.deviceID,  \r\n      UMI:  saleObject.UMI,  \r\n      dbConverter:saleObject.dbConverter,\r\n      trxTime:saleObject.trxTime,\r\n      origPA:parseFloat(saleObject.origPA),\r\n      initialTrxId:parseFloat(saleObject.initialTrxId),\r\n      entityId:parseFloat(entityId),\r\n      postableAmount:parseFloat(postableAmount),\r\n      redemptionType:parseFloat(redemptionType),\r\n      adjustedAmount:  { type: oracledb.NUMBER, dir : oracledb.BIND_OUT },\r\n      xlsTrxId:  { type: oracledb.NUMBER, dir : oracledb.BIND_OUT },\r\n       errorCode:  { type: oracledb.NUMBER, dir : oracledb.BIND_OUT },\r\n      errorDescription:  { type: oracledb.STRING, dir : oracledb.BIND_OUT }\r\n    }\r\n  '''\r\nPlease give some hits to solve this error,\r\n\r\nBest regards,\r\nSreeni\t"},"comment":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/comments/173538896","html_url":"https://github.com/oracle/node-oracledb/issues/322#issuecomment-173538896","issue_url":"https://api.github.com/repos/oracle/node-oracledb/issues/322","id":173538896,"user":{"login":"cjbj","id":200778,"avatar_url":"https://avatars.githubusercontent.com/u/200778?v=3","gravatar_id":"","url":"https://api.github.com/users/cjbj","html_url":"https://github.com/cjbj","followers_url":"https://api.github.com/users/cjbj/followers","following_url":"https://api.github.com/users/cjbj/following{/other_user}","gists_url":"https://api.github.com/users/cjbj/gists{/gist_id}","starred_url":"https://api.github.com/users/cjbj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cjbj/subscriptions","organizations_url":"https://api.github.com/users/cjbj/orgs","repos_url":"https://api.github.com/users/cjbj/repos","events_url":"https://api.github.com/users/cjbj/events{/privacy}","received_events_url":"https://api.github.com/users/cjbj/received_events","type":"User","site_admin":false},"created_at":"2016-01-21T11:04:34Z","updated_at":"2016-01-21T11:04:34Z","body":"@amjadparacha please send me the files that reproduce it. Thanks!"}}