title: returning a result set from a java stored procedure through SQL "select * from "
body: <p>Can I get the result from a java stored procedure (oracle) directly through an SQL <code>select * from</code> statement ? </p>
  
  <p>On the database I would have a java stored procedure / function, which when it called returns a multi-column, multi-row result set.<br>
  I would like to access these results directly through a <code>select * from [table]</code> statement.</p>
  
  <p>So the java stored procedure should behave like a table.<br>
  In MySQL the following should be possible (but not java stored procedures): <code>SELECT col1 FROM (EXEC proc1)</code></p>
  
  <p>Is this possible in oracle where proc1 is a java stored procedure?</p>