title: jTDS / JDBC call Store Procedure, error… getMoreResults()
body: <p>Here is code of my MS SQL Server Stored Procedure with have one input and one output parameter :</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[AddItem] @numer nvarchar(50) , @ff int Output
  AS
  BEGIN
      SELECT Category = @ff
      FROM [AWE_database].[dbo].[Items]
      WHERE Catalog_number=@numer     
  END
  </code></pre>
  
  <p>And I try to run it on my phone ( using Android Studio). To connect with my database I use jtds-1.3.1 library.  </p>
  
  <pre><code>try {
  
  CallableStatement cs ;
                cs = this.connect.prepareCall("{call AddItem(?,?)}");
                cs.setString(1, c);
                cs.registerOutParameter(2, java.sql.Types.INTEGER);
  
                int s = cs.getInt(2);
  
                cat = getString(s);
  
                Toast.makeText(getApplicationContext(), cat, Toast.LENGTH_SHORT).show();
  
  } catch (SQLException e) {e.printStackTrace(); }
  </code></pre>
  
  <p>I get such error: </p>
  
  <pre><code>java.sql.SQLException: Output parameters have not yet been processed. Call getMoreResults().
  </code></pre>
  
  <p>I searched the forum to find some sollution and tryed many examples but no one works. 
  How shoudl I use <code>getMoreResults()</code> ? 
  Or something other is wrong ? 
  I could add that I run procedures with return many parameters and it works. 
  But this procedure have also an input parameter.</p>
  
  <p>I am a beginner in programming. Please Help</p>