XML publisher report using pl_sql procedure -- Limit the number of rows in each page
HI All,
I am beginner in XML publisher report ..and have lots of difficulties while developing report
I developed a dummy XML publisher report with PL_SQL procedure but when report is printing out , it gives mutliple rows in a page where as I want to dispaly only 10 rows in my each page .
i am not able to attach documents in this forum so have pasted all code down --
I would like to ask few things...
1) Where should we write code to limit no of rows per page - is it in Pl/SQL proecudre or the Xml file generated after printing out the pl_sql output.