>>You can fetch the entire table, but if the table is big, you are better off in just getting a small subset of the data at a time.
>
>I have done this with SPs and pass-through - and I liked it - but the application is having to deal with nested cursors and parameter protocols.
I am afraid that some re-design can't be avoided, unless you started thinking multi-tier or something similar in the first place (or use a framework which does this for you).
I haven't done practical work with C/S yet - didn't have the need to do it.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)