title: How to call a 'view' using callablestatement
body: <p>I thought it would be a simple google search, but I can't find an answer to this:</p>
  
  <p>I'm moving Access db to SQL Server, I have turned some of the queries into views. My Java application used to call every query using simple:</p>
  
  <pre><code>{ call dbo.GetOtherRanges() } //Well, not entirely true - Access did not use 'dbo' schema in front of the name
  </code></pre>
  
  <p>This works for stored procedures. But when I do that on views I receive the following:</p>
  
  <pre><code>[SQL Server]The request for procedure 'GetOtherRanges' failed because 'GetOtherRanges' is a view object.
  </code></pre>
  
  <p>I thought it would be as simple as removing the <code>()</code> brackets after the name of the view, but that didn't do the trick. </p>
  
  <ul>
  <li>How do I 'call' the views using JDBC CallableStatment?</li>
  <li>Is there a different way of calling table-valued functions as well?</li>
  </ul>