RETURNING ROWS FROM A STORED PROCEDURE

From: B. Zuydervliet <Zuyderb_at_alliedsignal.com>
Date: 1997/03/24
Message-ID: <5h60f1$8oh@snowhite.mto.allied.com>#1/1

Hi,

I'm developing an application using VB v4.0 using the Oracle ODBC driver.

I would like to completely partition the front end application from the underlying SQL code. I would like to do this using stored procedures. This works fine for UPDATES, INSERTS and DELETES.

However I would like to be able to call a stored procedure (perhaps with a parameters) which runs a SELECT statement. The result set of which I would like returning to a VB data control or recordset variable.

Can anyone help? I would greatly appreciate any help/sample code.

TIA Andy Noble. Received on Mon Mar 24 1997 - 00:00:00 CST