From: "Barbara Kennedy" <barbken@teleport.com>
Newsgroups: comp.databases.oracle.server
References: <39E1C026.FC9CDBBF@free.fr>
Subject: Re: Using ADO and Oracle 8i
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300
Message-ID: <xeFE5.26105$F65.1729194@nntp2.onemain.com>
Date: Tue, 10 Oct 2000 06:57:56 -0700
NNTP-Posting-Host: 216.26.5.147
X-Complaints-To: abuse@onemain.com
X-Trace: nntp2.onemain.com 971186205 216.26.5.147 (Tue, 10 Oct 2000 09:56:45 EDT)
NNTP-Posting-Date: Tue, 10 Oct 2000 09:56:45 EDT


Yes, but you don't need a stored procedure to do it. Just open a cursor.  A
more efficient way is to use Oracle's OLE objects.  It is pretty easy to
use.
Jim
"Rémi DEJARDIN" <remid@free.fr> wrote in message
news:39E1C026.FC9CDBBF@free.fr...
> I'm new with Oracle and I got a big problem
> I used SQL Server for a long time and with Transac SQL, I was used to
> return select with stored procedures
>
> Is it possible to return a lot of records like SQL Server and to use it
> with ADO ?
>
> Thanks:
>
> Answers to mailto:remid@csi.fr