title: how to execute pl/sql stored procedure havaing sys_refcursor as out parameter
body: <pre><code>create or replace procedure get_emp(p_deptno number,emp_det out sys_refcursor)
  is
  begin
  open emp_det for select * from emp where deptno=p_deptno;
  end;
  /
  </code></pre>
  
  <p>how to pass parameters for sys_refcursor and how to print that result using anonymous blocks in oracle pl/sql</p>