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
i'm wrong, my mistake
my sql has an ORDER BY, thats why its fetching all rows
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.