OLE ,Oracle, ans Stored Procedures returning result sets
Date: 2000/08/08
Message-ID: <8mpfge$hce$1_at_kermit.esat.net>#1/1
[Quoted] We are currently using Microsoft ADO 2.0 to Connect to Oracle 7.3.4.3. We have established that we can call a procedure or package using OLE or ODBC, using PL/SQL tables.
However, if we want to return a result set, from a package, then we at present can only use the ODBC driver, as in all the examples provided in the MSDN, or on various Web Sites.
I need a mechanism to enable me to connect to a stored procedure using OLE
which returns a result set.
[Quoted] Does anyone have any examples of how I can do this. I am aware that I may
have to change the procedures to use Ref Cursors, but this should be a minor
[Quoted] [Quoted] issue, unless of course anyone else knows better.
TIA Keith Received on Tue Aug 08 2000 - 00:00:00 CEST