From: Walter T Rejuney <BlueSax@Unforgetable.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Using ADO and Oracle 8i
Date: Tue, 10 Oct 2000 10:35:34 -0400
Organization: xyzzy
Lines: 17
Message-ID: <39E32936.D7D5E276@Unforgetable.com>
References: <39E1C026.FC9CDBBF@free.fr> <xeFE5.26105$F65.1729194@nntp2.onemain.com>
Reply-To: BlueSax@Unforgetable.com
NNTP-Posting-Host: ga0235kstahl.mmr.avaya.com
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Mailer: Mozilla 4.73 [en] (Win95; U)
X-Accept-Language: en


Barbara Kennedy wrote:

> 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 ?

Keeping in mind that OO4O is really Oracle OCI in a simplified wrapper.