Re: Returning Record Sets (Oracle 7.3.4) via ADO

I'm sorry, but you can retrieve a PL/SQL table from stored procedures. Just use the OO4O (Oracle Objects for OLE), and read the help file supplied with it.

Micha Huybrechts

Brena Balázs <brenab_at_westel900.hu> wrote in message news:3820910C.BE90EAA3_at_westel900.hu...
> Hi!
>
> To my best knowledge, no programming environment based on OCI (Oracle Call
> Interface) can retrieve record-based
> PLSQL tables from stored procedures (certainly not from Oracle 7).
> However, I gonna check with my local OCI guru tomorrow. Keep cool..
>
> Hali
> Bali
>
> Keith Jamieson wrote:
>
> > Heres the situation. I have written PL/SQL procedures and Functions
which
> > return record sets in oracle.
> > The VB developers here have managed to retrieve recordsets when
> > each of the columns in the record set is declared as an out parameter
within
> > a procedure.
> >
> > This is based on the example given in URL support.microsoft.com
> >
> > Article-ID Q174679
> > Title How to retrieve resultsets from oracle stored procedures.
> >
> > PL/SQL 2.3 allows you to base PLSQL tables on records.
> > We have verified the functions and procedures from within Oracle and
they do
> > operate as expected.
> > However when we call the procedure, a type mismatch error message is
> > received:
> > Does anyone have any examples, or know whether ADO supports this
feature?
>
Received on Thu Nov 04 1999 - 08:38:00 CST