title: Laravel 5 stored procedure error
body: <p>I am running a stored procedure from my form on submit. However, I keep getting the following error: </p>
  
  <blockquote>
    <p>The active result for the query contains no fields.</p>
  </blockquote>
  
  <p>Below is what I have tried. 
  Code to execute SP
  <code>DB::select('EXEC myStored_Procedure');</code></p>
  
  <p>I have also tried</p>
  
  <pre><code>DB::select('SET NOCOUNT ON;  EXEC myStored_Procedure');
  </code></pre>
  
  <p>But both return the same error. I have also used <code>Set NOCOUNT ON;</code> within the stored procedure itself, but with the error still occurs. </p>
  
  <p>My SP works fine and my web page works fine separately, but when I call the SP from the web page it always returns this error. </p>
  
  <p>How can I get around this error?</p>