Re: Returning Result Sets to ADO client
From: Norris <johnnie_at_cooper.com.hk>
Date: 3 Oct 1999 03:54:22 GMT
Message-ID: <7t6k1e$of5$1_at_adenine.netfront.net>
>>It would be easier and faster to use Oracle Object for OLE to handle PL/SQL
>>
>>Keith Jamieson <jamiesonk_at_phoenix.ie> wrote:
>>> I want to create a stored procedure which returns a result set via an
>>> oracle driver to a client that uses ADO.
>>
>>> The client will be using either Visual BAsic or/and Java.
>>
>>> Does anyone have an example of how this is done,
>>
>>> TIA
>>
>>> Keith
>>
>>
>>
>>
>>
>>
>>--
>>- Have several nice days...
>>- Opinions are mine and do not necessarily reflect those of the Corp.
>>http://www.ntfaq.com
>>http://www.cyberport.com/~tangent/programming/winsock/
Date: 3 Oct 1999 03:54:22 GMT
Message-ID: <7t6k1e$of5$1_at_adenine.netfront.net>
[Quoted] I only know how to get stored proc result set in ADO/OLEDB for SQLServer
Keith Jamieson <jamiesonk_at_phoenix.ie> wrote: > I'm afraid I am restricted to what I can use, however, I will look at any > examples you may be prepared to send/post.
> Norris wrote in message <7svql9$hop$1_at_adenine.netfront.net>...
>>It would be easier and faster to use Oracle Object for OLE to handle PL/SQL
> Stored Proc multiple result sets than ADO/OLEDB.
>>
>>Keith Jamieson <jamiesonk_at_phoenix.ie> wrote:
>>> I want to create a stored procedure which returns a result set via an
> OLEDB
>>> oracle driver to a client that uses ADO.
>>
>>> The client will be using either Visual BAsic or/and Java.
>>
>>> Does anyone have an example of how this is done,
>>
>>> TIA
>>
>>> Keith
>>
>>
>>
>>
>>
>>
>>--
>>- Have several nice days...
>>- Opinions are mine and do not necessarily reflect those of the Corp.
>>http://www.ntfaq.com
>>http://www.cyberport.com/~tangent/programming/winsock/
-- - Have several nice days... - Opinions are mine and do not necessarily reflect those of the Corp. http://www.ntfaq.com http://www.cyberport.com/~tangent/programming/winsock/Received on Sun Oct 03 1999 - 05:54:22 CEST