Re: How best to Return a "Recordset"?

Package and ref cursor is probably your best bet.

In article <SV796.2336$mo2.195371_at_news1.news.adelphia.net>,   "Brian Y." <NOSP_at_M> wrote:
> I want to use VB/ADO to call an Oracle database "object" that will
 return a
> recordset to the client (e.g., the return of Command.Execute(...) in
 a VB
> module). What is the best approach to accomplishing this? I've
 investigated
> stored procedures returning cursors via an IN OUT parameter, functions
> returning cursors, and packages (which I'm not too familiar with). Any
> thoughts? Thanks.
>
> We're using Oracle 7.3.
>
> B~
>
>

--
Jining Han
Sallie Mae


Sent via Deja.com
http://www.deja.com/