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

Free Newsletters, In your Inbox