Dynamic Paging of Data, Retrieve XML instead of REF CURSOR

A couple of days ago I wrote about paging through data using a REF CURSOR and dynamic SQL. Today I'm going to expand on that. Instead of using a REF CURSOR, it would be nice to pull back an XML document with just the subset of records the REF CURSOR would normally provide.

Editor's Picks