refcursor v.s. host arrays and... pro*c... and ODBC

Hello. I asked this question before in various places.. I mostly heard "use a refcursor". Now I heard "use host arrays".

If I have a stored procedure which
1) needs to return large amounts of data which is build by much work on the database, i.e. not the result of a single query 2) needs to minimize trips to the server

1. Are refcursor or host arrays better? (I am guessing host arrays, but am not sure)
2. can someone shoe me an example of refcursors in pro*c (I see an example of host arrays with pro*c in the Oracle documentation)
3. Are these accessible from odbc also, and if so, does someone have an example?

Thanks
Jeff Kish
p.s. cc emails appreciated
kishj_at_earthlink.net Received on Mon Jan 29 2001 - 21:19:24 CST