>>>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.

I guess we're both "layer" developers:)