ref_cursor_to_json maxrows problem

bedorlan
2013-07-03
2013-07-03
  • bedorlan
    bedorlan
    2013-07-03

    In the procedure json_util_pkg.ref_cursor_to_json
    dbms_xmlgen.setmaxrows only works with dbms_xmlgen.getxml
    dbms_xmlgen.getxmltype is fetching all rows

    tested in oracle 11g

     
    • bedorlan
      bedorlan
      2013-07-03

      i'm wrong, my mistake
      my sql has an ORDER BY, thats why its fetching all rows