How to get a recordset into VB from Oracle Stored Procedure

From: Ian Carrick <ian_at_rombus.co.uk>
Date: Fri, 10 Nov 2000 14:34:52 -0000
Message-ID: <973866755.26348.0.nnrp-01.c2de47d8@news.demon.co.uk>

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? Received on Fri Nov 10 2000 - 08:34:52 CST