Re: How to get a recordset into VB from Oracle Stored Procedure

In article <973866755.26348.0.nnrp-01.c2de47d8_at_news.demon.co.uk>,   "Ian Carrick" <ian_at_rombus.co.uk> wrote:
> I've been used to SQL Server 7 and stored procedures. I've used VB to
> access stored procedures and return records into recordsets. I'm now
 having
> to do exactly the same but with Oracle 8i. I'm having trouble getting
 my
> head round how Oracle works and how you get a recordset from a stored
> procedure.
>
> Do you use packages to do such things and how do you get recordsets
 from a
> stored procedure. I read somewhere that 'ref cursors' cannot be used
 in
> Oracle to pass recordsets back. If that's the case how do you dot it?

You can certainly get resultsets from stored procedures in Oracle. You'll have your choice of API's-- ODBC, OLE DB, OO4O, RDO, DAO, ADO, etc.

In general, the way you do this is to create a procedure that returns a REF CURSOR as an OUT parameter, then call that procedure from your VB app using whichever API you selected.

--
Justin Cave - Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of
Oracle Corporation.


Sent via Deja.com http://www.deja.com/
Before you buy.