title: How to call PostgreSQL stored procedures with JDBC
body: <p>I'm using postgresql and I have created some stored procedures. Now I want to access the stored procedures via jdbc and process the results. The results of the stored procedures are either integer or a TABLE.</p>
  
  <p>I found the following:</p>
  
  <pre><code>CallableStatement upperProc = conn.prepareCall("{ ? = call upper( ? ) }");
  upperProc.registerOutParameter(1, Types.VARCHAR);
  upperProc.setString(2, "lowercase to uppercase");
  upperProc.execute();
  String upperCased = upperProc.getString(1);
  upperProc.close();
  </code></pre>
  
  <p>With this I think I can process the single integer return but how can I process the TABLE returns?</p>