title: ORDS: How to retrieve json response using refcursor in plsql ords
body: <p>I am trying to get the json response using the ref cursor but it is returning error.
  Main Procedure:</p>
  <pre><code>CREATE OR REPLACE PROCEDURE GET_EMPLOYEE_ALL1(p_emp_no IN test_dec.emp_no%type,p_emp_output OUT SYS_REFCURSOR) IS 
     BEGIN 
         OPEN p_emp_output FOR select * from test_dec where emp_no=p_emp_no;
     END GET_EMPLOYEE_ALL1;
  </code></pre>
  <p>Handler and Parameter is defined as under.</p>
  <pre><code>BEGIN
  ords.define_template(p_module_name =&gt; 'rest-v1',
  p_pattern =&gt; 'employee/get_employee_all/');
  
  ords.define_handler(p_module_name =&gt; 'rest-v1',
  p_pattern =&gt;'employee/get_employee_all/',
  p_method =&gt;'POST',
  p_source_type =&gt;ORDS.source_type_plsql,
  p_mimes_allowed    =&gt; 'application/json',
  p_source =&gt;'DECLARE emp_detail SYS_REFCURSOR; BEGIN rest_package.get_employee_all(p_emp_no =&gt; :emp_no,p_emp_output =&gt; :emp_detail); p_emp_output := :emp_detail; END;',             
  p_items_per_page =&gt;0);
  
  COMMIT;
  END;
  
  
  BEGIN
   ORDS.define_parameter(
      p_module_name        =&gt; 'rest-v1',
      p_pattern            =&gt; 'employee/get_employee_all/',
      p_method             =&gt; 'POST',
      p_name               =&gt; 'emp_detail',
      p_bind_variable_name =&gt; 'emp_detail',
      p_source_type        =&gt; 'RESPONSE',
      p_param_type         =&gt; 'RESULTSET',
      p_access_method      =&gt; 'OUT'
    );
  END;
  </code></pre>
  <p>While running from POSTMAN I am getting and 403 Erorr:
  The request could not be processed because a function or procedure referenced by the PL/SQL statement being evaluated is not accessible or does not exist</p>