{"action":"created","issue":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/105","labels_url":"https://api.github.com/repos/oracle/node-oracledb/issues/105/labels{/name}","comments_url":"https://api.github.com/repos/oracle/node-oracledb/issues/105/comments","events_url":"https://api.github.com/repos/oracle/node-oracledb/issues/105/events","html_url":"https://github.com/oracle/node-oracledb/issues/105","id":81219211,"number":105,"title":"[The specified procedure could not be found. ] error on node-oracle","user":{"login":"CarlosRen","id":6012322,"avatar_url":"https://avatars.githubusercontent.com/u/6012322?v=3","gravatar_id":"","url":"https://api.github.com/users/CarlosRen","html_url":"https://github.com/CarlosRen","followers_url":"https://api.github.com/users/CarlosRen/followers","following_url":"https://api.github.com/users/CarlosRen/following{/other_user}","gists_url":"https://api.github.com/users/CarlosRen/gists{/gist_id}","starred_url":"https://api.github.com/users/CarlosRen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CarlosRen/subscriptions","organizations_url":"https://api.github.com/users/CarlosRen/orgs","repos_url":"https://api.github.com/users/CarlosRen/repos","events_url":"https://api.github.com/users/CarlosRen/events{/privacy}","received_events_url":"https://api.github.com/users/CarlosRen/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/oracle/node-oracledb/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-05-27T01:39:08Z","updated_at":"2015-05-27T18:05:53Z","closed_at":null,"body":"hi\r\nthis is my code:\r\napp-oracle.js\r\n```\r\nfunction oracledb(){\r\n  var oracledb = require('oracledb');\r\n  oracledb.getConnection(\r\n  {\r\n    user          : \"fundsdev\",\r\n    password      : \"fundsdev\",\r\n    connectString : \"10.6.10.141/fundsdev\"\r\n  },\r\n  function(err, connection)\r\n  {\r\n    if (err) {\r\n      console.error(err.message);\r\n      return;\r\n    }\r\n    connection.execute(\r\n      \"SELECT * from sys_middle sys_middleprice_num orderby middleprice_date desc\",\r\n      [0],\r\n      function(err, result)\r\n      {\r\n        if (err) {\r\n          console.error(err.message);\r\n          return;\r\n        }\r\n        console.log(result.rows);\r\n        return result.rows;\r\n      });\r\n  });\r\n\r\n}\r\nexports.orcl = oracledb;\r\n```\r\napp.js\r\n```\r\napp.get('/orcl',function(req, res, next){\r\n\tvar result = oracleop.orcl();\r\n\tres.send(result);\r\n});\r\n```\r\n\r\nand this is the error when i calling function by url \r\n\r\nThe specified procedure could not be found. D:\\mircospider\\node_modules\\oracledb\\build\\Release\\oracledb.node\r\n```\r\nThe specified procedure could not be found. D:\\mircospider\\node_modules\\oracledb\\build\\Release\\oracledb.node\r\n\r\nError: The specified procedure could not be found.\r\nD:\\mircospider\\node_modules\\oracledb\\build\\Release\\oracledb.node\r\n    at Module.load (module.js:356:32)\r\n    at Function.Module._load (module.js:312:12)\r\n    at Module.require (module.js:364:17)\r\n    at require (module.js:380:17)\r\n    at Object.<anonymous> (D:\\mircospider\\node_modules\\oracledb\\lib\\oracledb.js:23:15)\r\n    at Module._compile (module.js:456:26)\r\n    at Object.Module._extensions..js (module.js:474:10)\r\n    at Module.load (module.js:356:32)\r\n    at Function.Module._load (module.js:312:12)\r\n    at Module.require (module.js:364:17)\r\n```\r\n\r\nis the way i using node-oracle wrong? or it is a problem of node-oracle?\r\ni can't fix it ,wish your help"},"comment":{"url":"https://api.github.com/repos/oracle/node-oracledb/issues/comments/106016087","html_url":"https://github.com/oracle/node-oracledb/issues/105#issuecomment-106016087","issue_url":"https://api.github.com/repos/oracle/node-oracledb/issues/105","id":106016087,"user":{"login":"dmcghan","id":585767,"avatar_url":"https://avatars.githubusercontent.com/u/585767?v=3","gravatar_id":"","url":"https://api.github.com/users/dmcghan","html_url":"https://github.com/dmcghan","followers_url":"https://api.github.com/users/dmcghan/followers","following_url":"https://api.github.com/users/dmcghan/following{/other_user}","gists_url":"https://api.github.com/users/dmcghan/gists{/gist_id}","starred_url":"https://api.github.com/users/dmcghan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dmcghan/subscriptions","organizations_url":"https://api.github.com/users/dmcghan/orgs","repos_url":"https://api.github.com/users/dmcghan/repos","events_url":"https://api.github.com/users/dmcghan/events{/privacy}","received_events_url":"https://api.github.com/users/dmcghan/received_events","type":"User","site_admin":false},"created_at":"2015-05-27T18:05:53Z","updated_at":"2015-05-27T18:05:53Z","body":"@CarlosRen After you address the PATH and release() issues, you'll also need to address an async issue... Currently your app.js is calling oracleop.orcl as though it's synchronous, which it is not. You'll need to update your oracledb function in app-oracledb.js to accept a callback which is invoked at the right time. Then your app.js would look like this:\r\n\r\napp.get('/orcl',function(req, res, next){\r\n    oracleop.orcl(function(result) {\r\n        res.send(result);\r\n   });\r\n});"}}