{"action":"created","issue":{"url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/196","repository_url":"https://api.github.com/repos/ibmdb/node-ibm_db","labels_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/196/labels{/name}","comments_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/196/comments","events_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/196/events","html_url":"https://github.com/ibmdb/node-ibm_db/issues/196","id":190644063,"number":196,"title":"CLI0123E: SQL data type out of range. SQLSTATE=HY004","user":{"login":"ljerka","id":11440636,"avatar_url":"https://avatars.githubusercontent.com/u/11440636?v=3","gravatar_id":"","url":"https://api.github.com/users/ljerka","html_url":"https://github.com/ljerka","followers_url":"https://api.github.com/users/ljerka/followers","following_url":"https://api.github.com/users/ljerka/following{/other_user}","gists_url":"https://api.github.com/users/ljerka/gists{/gist_id}","starred_url":"https://api.github.com/users/ljerka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ljerka/subscriptions","organizations_url":"https://api.github.com/users/ljerka/orgs","repos_url":"https://api.github.com/users/ljerka/repos","events_url":"https://api.github.com/users/ljerka/events{/privacy}","received_events_url":"https://api.github.com/users/ljerka/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":31,"created_at":"2016-11-21T08:02:32Z","updated_at":"2016-12-28T13:41:50Z","closed_at":null,"body":"I am having a problem with calling stored procedure that has output parameters. This is the error:\r\n```\r\nData is missing from [object Object]\r\n{ Error: [IBM][CLI Driver] CLI0123E  SQL data type out of range. SQLSTATE=HY004  at Error (native)\r\n  errors: [],\r\n  error: '[node-odbc] SQL_ERROR',\r\n  message: '[IBM][CLI Driver] CLI0123E  SQL data type out of range. SQLSTATE=HY004',\r\n  state: 'HY004' }\r\n```\r\n\r\nMy code:\r\n```\r\nibmdb.open(driver+hostname+port+db+user+psw+protocol, function (err,conn) {\r\n     if (err) return console.log(err);\r\n\r\n     var query = \"CaLL name.mySP(?,?,?,?,?,?,?,?,?,?,?)\";\r\n\r\n     var param1 = {ParamType:\"INPUT\", DataType:1, Data:\"\"};\r\n     var param2 = {ParamType:\"INPUT\", DataType:1, Data:\"\"};\r\n     var param3 = {ParamType:\"INPUT\", DataType:1, Data:76145};\r\n     var param4 = {ParamType:\"INPUT\", DataType:1, Data:0};\r\n     var param5 = {ParamType:\"INPUT\", DataType:1, Data:0};\r\n     var param6 = {ParamType:\"INPUT\", DataType:1, Data:0};\r\n     var param7 = {ParamType:\"INPUT\", DataType:1, Data:\"\"};\r\n\r\n     var param8 = {ParamType:\"OUTPUT\", DataType:1, Data:0};\r\n     var param9 = {ParamType:\"OUTPUT\", DataType:1, Data:0};\r\n     var param10 = {ParamType:\"OUTPUT\", DataType:1, Data:\"\"};\r\n     var param11 = {ParamType:\"OUTPUT\", DataType:1, Data:0};\r\n\r\n     conn.query(query, [param1,param2,param3,param4,param5,param6,param7,param8,param9,param10,param11], function (err, data) {\r\n          if (err) console.log(err);\r\n          else console.log(data);\r\n\r\n          conn.close(function () { console.log('>> closed'); });\r\n     });\r\n});\r\n```\r\nI was able to call stored procedure that has only input params but am unable to call any procedure that also has output params.\r\n\r\nAny idea?"},"comment":{"url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/comments/269478528","html_url":"https://github.com/ibmdb/node-ibm_db/issues/196#issuecomment-269478528","issue_url":"https://api.github.com/repos/ibmdb/node-ibm_db/issues/196","id":269478528,"user":{"login":"ljerka","id":11440636,"avatar_url":"https://avatars.githubusercontent.com/u/11440636?v=3","gravatar_id":"","url":"https://api.github.com/users/ljerka","html_url":"https://github.com/ljerka","followers_url":"https://api.github.com/users/ljerka/followers","following_url":"https://api.github.com/users/ljerka/following{/other_user}","gists_url":"https://api.github.com/users/ljerka/gists{/gist_id}","starred_url":"https://api.github.com/users/ljerka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ljerka/subscriptions","organizations_url":"https://api.github.com/users/ljerka/orgs","repos_url":"https://api.github.com/users/ljerka/repos","events_url":"https://api.github.com/users/ljerka/events{/privacy}","received_events_url":"https://api.github.com/users/ljerka/received_events","type":"User","site_admin":false},"created_at":"2016-12-28T13:41:50Z","updated_at":"2016-12-28T13:41:50Z","body":"Win7"}}
{"actor":{"display_login":"ljerka"}}