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

       

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks