{"action":"created","issue":{"url":"https://api.github.com/repos/pekim/tedious/issues/267","labels_url":"https://api.github.com/repos/pekim/tedious/issues/267/labels{/name}","comments_url":"https://api.github.com/repos/pekim/tedious/issues/267/comments","events_url":"https://api.github.com/repos/pekim/tedious/issues/267/events","html_url":"https://github.com/pekim/tedious/issues/267","id":79900480,"number":267,"title":"Stored Procedure Parameters","user":{"login":"asperand87","id":7646397,"avatar_url":"https://avatars.githubusercontent.com/u/7646397?v=3","gravatar_id":"","url":"https://api.github.com/users/asperand87","html_url":"https://github.com/asperand87","followers_url":"https://api.github.com/users/asperand87/followers","following_url":"https://api.github.com/users/asperand87/following{/other_user}","gists_url":"https://api.github.com/users/asperand87/gists{/gist_id}","starred_url":"https://api.github.com/users/asperand87/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/asperand87/subscriptions","organizations_url":"https://api.github.com/users/asperand87/orgs","repos_url":"https://api.github.com/users/asperand87/repos","events_url":"https://api.github.com/users/asperand87/events{/privacy}","received_events_url":"https://api.github.com/users/asperand87/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-05-23T17:07:54Z","updated_at":"2015-05-27T14:49:30Z","closed_at":"2015-05-27T14:49:30Z","body":"Hi,\r\n\r\ni'm calling a stored procedure on SQL Server 2012. But connection.execSql give me back this error:\r\n\r\nServer running at http://127.0.0.1:1337/\r\n```\r\n{ [RequestError: Procedure or function 'ArtSrc' expects parameter '@codArt', which was not supplied.]\r\n  name: 'RequestError',\r\n  message: 'Procedure or function \\'ArtSrc\\' expects parameter \\'@codArt\\', which was not supplied.',\r\n  code: 'EREQUEST',\r\n  number: 201,\r\n  state: 4,\r\n  class: 16,\r\n  serverName: 'PCBASE\\\\SQLSRV2012',\r\n  procName: 'ArtSrc',\r\n  lineNumber: 0 }\r\n```\r\nof course i've set them.\r\ni added a log on request.transformIntoExecuteSqlRpc\r\nand this is the result:\r\n\r\n```\r\n{ type:\r\n   { type: 'NVARCHAR',\r\n     name: 'NVarChar',\r\n     hasCollation: true,\r\n     dataLengthLength: 2,\r\n     maximumLength: 4000,\r\n     declaration: [Function],\r\n     resolveLength: [Function],\r\n     writeTypeInfo: [Function],\r\n     writeParameterData: [Function],\r\n     validate: [Function],\r\n     id: 231 },\r\n  name: 'codArt',\r\n  value: 'a',\r\n  output: false,\r\n  length: 20,\r\n  precision: undefined,\r\n  scale: undefined }\r\n{ type:\r\n   { type: 'NVARCHAR',\r\n     name: 'NVarChar',\r\n     hasCollation: true,\r\n     dataLengthLength: 2,\r\n     maximumLength: 4000,\r\n     declaration: [Function],\r\n     resolveLength: [Function],\r\n     writeTypeInfo: [Function],\r\n     writeParameterData: [Function],\r\n     validate: [Function],\r\n     id: 231 },\r\n  name: 'dscArt',\r\n  value: 'a',\r\n  output: false,\r\n  length: 255,\r\n  precision: undefined,\r\n  scale: undefined }\r\n```\r\n\r\nwhere can i look?\r\n\r\nthanks"},"comment":{"url":"https://api.github.com/repos/pekim/tedious/issues/comments/105941487","html_url":"https://github.com/pekim/tedious/issues/267#issuecomment-105941487","issue_url":"https://api.github.com/repos/pekim/tedious/issues/267","id":105941487,"user":{"login":"bretcope","id":3608260,"avatar_url":"https://avatars.githubusercontent.com/u/3608260?v=3","gravatar_id":"","url":"https://api.github.com/users/bretcope","html_url":"https://github.com/bretcope","followers_url":"https://api.github.com/users/bretcope/followers","following_url":"https://api.github.com/users/bretcope/following{/other_user}","gists_url":"https://api.github.com/users/bretcope/gists{/gist_id}","starred_url":"https://api.github.com/users/bretcope/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bretcope/subscriptions","organizations_url":"https://api.github.com/users/bretcope/orgs","repos_url":"https://api.github.com/users/bretcope/repos","events_url":"https://api.github.com/users/bretcope/events{/privacy}","received_events_url":"https://api.github.com/users/bretcope/received_events","type":"User","site_admin":false},"created_at":"2015-05-27T14:49:30Z","updated_at":"2015-05-27T14:49:30Z","body":"Try `callProcedure` as olivarvar suggests. You can re-open if there's still an issue."}}