title: Java: Read metadata from procedure
body: <p>I am looking for a way to get metadata from an Oracle store procedure, such as input/output parameters and their types.</p>
  
  <p>I did try <code>DESC</code> but it is not working:</p>
  
  <pre><code>stmt = conn.createStatement();
  ResultSet rs1 = stmt.executeQuery("desc pack.procname");
  while ( rs1.next() ) { 
  System.out.println(rs1.getString(1));
  }
  </code></pre>
  
  <p>Any ideas on what approach to use to get the input/output parameters?</p>
  
  <p>Thanx for your time.</p>