title: Oracle stored procedure: return both result set and out parameters
body: <p>Oracle stored procedure has OUT parameter and returns result set, e.g.</p>
  
  <pre><code>create or replace procedure foo(empId IN NUMBER, maxSalary OUT NUMBER) AS BEGIN
      select * from Employee e where e.id &gt;=empId;
      select max(salary) into maxSalary from Employee;
  END;
  </code></pre>
  
  <p>ERROR:</p>
  
  <pre><code>PLS-00428: an INTO clause is expected in this SELECT statement
  </code></pre>
  
  <p>Mysql stored procedure can return both result sets and out parameters. How to do it for oracle db?</p>