{"id":3137,"date":"2019-03-25T17:42:52","date_gmt":"2019-03-25T20:42:52","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/"},"modified":"2020-01-23T10:08:16","modified_gmt":"2020-01-23T13:08:16","slug":"kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/","title":{"rendered":"KB-55539: Running a Stored Procedure in E3 with input\/output data."},"content":{"rendered":"
Question:<\/b><\/p>\n

How can I run a Stored Procedure in E3 that passes input data and reads output data?
\n
\nSolution:<\/b><\/p>\n

To do so, follow these procedures:<\/p>\n

1. Declare the output variable:
\nDECLARE @output int<\/span><\/p>\n

2. Use EXEC <\/span>command, passing the input value and informing the output:
\nEXEC SP_INSERT_ASSEMBLER ‘<\u00a8%output_variable%>‘, @output OUTPUT<\/span><\/p>\n

3. Create an alias for the return field:
\nSELECT @output as result<\/span><\/p>\n

The whole code:
\nDECLARE @output int
\nEXEC SP_INSERT_ASSEMBLER ‘<\u00a8%input_variable%>‘, @output OUTPUT
\nSELECT @output as result<\/span><\/p>\n

NOTE<\/b>: In case the stored procedure has another output result, such as INSERT<\/span>, for example, E3 will return null, with no output value. This happens because E3 only has access to the first result in a query, and in this case, the aforementioned result is INSERT<\/span>, which is null. To work around this, just set SET NOCOUNT ON <\/span>command before executing the stored procedure, and then set it off at the end. This command turns off the database’s return messages regarding the number of record affected by commands INSERT <\/span>and UPDATE<\/span>, and thus makes way E3Query to receive the return value of the stored procedure.<\/p>\n

Example:
\nSET NOCOUNT ON
\nDECLARE @output int
\nEXEC SP_INSERT_ASSEMBLER ‘<\u00a8%input_variable%>‘, @output OUTPUT
\nSELECT @output as result
\nSET NOCOUNT OFF<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

Question: How can I run a Stored Procedure in E3 that passes input data and reads output data? Solution: To do so, follow these procedures: 1. Declare the output variable:…<\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[743],"tags":[],"yoast_head":"\nKB-55539: Running a Stored Procedure in E3 with input\/output data. - Elipse Knowledgebase<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB-55539: Running a Stored Procedure in E3 with input\/output data.\" \/>\n<meta property=\"og:description\" content=\"Question: How can I run a Stored Procedure in E3 that passes input data and reads output data? Solution: To do so, follow these procedures: 1. Declare the output variable:…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:42:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-23T13:08:16+00:00\" \/>\n<meta name=\"author\" content=\"C\u00e9zar Lumiatti Teixeira\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"C\u00e9zar Lumiatti Teixeira\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/\"},\"author\":{\"name\":\"C\u00e9zar Lumiatti Teixeira\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/843cbcdf9865f72399446377cf0cfc2b\"},\"headline\":\"KB-55539: Running a Stored Procedure in E3 with input\/output data.\",\"datePublished\":\"2019-03-25T20:42:52+00:00\",\"dateModified\":\"2020-01-23T13:08:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/\"},\"wordCount\":233,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"E3Query\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/\",\"name\":\"[:pt]KB-55539: Running a Stored Procedure in E3 with input\/output data.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:42:52+00:00\",\"dateModified\":\"2020-01-23T13:08:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB-55539: Running a Stored Procedure in E3 with input\/output data.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/843cbcdf9865f72399446377cf0cfc2b\",\"name\":\"C\u00e9zar Lumiatti Teixeira\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8ab17a30c6ba62b79eaefe2a0a0b8b1b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8ab17a30c6ba62b79eaefe2a0a0b8b1b?s=96&d=mm&r=g\",\"caption\":\"C\u00e9zar Lumiatti Teixeira\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/teixeira\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KB-55539: Running a Stored Procedure in E3 with input\/output data. - Elipse Knowledgebase","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]KB-55539: Running a Stored Procedure in E3 with input\/output data.[:] - Elipse Knowledgebase","og_description":"Question: How can I run a Stored Procedure in E3 that passes input data and reads output data? Solution: To do so, follow these procedures: 1. Declare the output variable:…","og_url":"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:42:52+00:00","article_modified_time":"2020-01-23T13:08:16+00:00","author":"C\u00e9zar Lumiatti Teixeira","twitter_card":"summary_large_image","twitter_misc":{"Written by":"C\u00e9zar Lumiatti Teixeira","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/"},"author":{"name":"C\u00e9zar Lumiatti Teixeira","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/843cbcdf9865f72399446377cf0cfc2b"},"headline":"KB-55539: Running a Stored Procedure in E3 with input\/output data.","datePublished":"2019-03-25T20:42:52+00:00","dateModified":"2020-01-23T13:08:16+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/"},"wordCount":233,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["E3Query"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/","url":"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/","name":"[:pt]KB-55539: Running a Stored Procedure in E3 with input\/output data.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:42:52+00:00","dateModified":"2020-01-23T13:08:16+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/kb55539-running-a-stored-procedure-in-e3-with-inputoutput-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"KB-55539: Running a Stored Procedure in E3 with input\/output data."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/843cbcdf9865f72399446377cf0cfc2b","name":"C\u00e9zar Lumiatti Teixeira","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8ab17a30c6ba62b79eaefe2a0a0b8b1b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8ab17a30c6ba62b79eaefe2a0a0b8b1b?s=96&d=mm&r=g","caption":"C\u00e9zar Lumiatti Teixeira"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/teixeira\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3137"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=3137"}],"version-history":[{"count":1,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3137\/revisions"}],"predecessor-version":[{"id":9953,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3137\/revisions\/9953"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=3137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=3137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=3137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}