Re: Is it possible to return recordset from oracle stored procedure ?

VB cannot retrieve data from an Oracle stored procedure if you are using ODBC to connect the client. I only work from the PL/SQL side, and as far as I know from my co-workers who do the programs in VB, you can use Oracle OLE to retrieve data from stored procedures, but its not possible if you use an ODBC connection. We had to resort to populating "temporary" tables.

Vjacheslav Saiko wrote:

> Calling programm may be Delphi, or VB.
> The task is to create stored procedure, which may return recordset to
> client;
> i can't find in oracle documenttion , how to do it.
>
> Thanks !
>
> Fenella Tan wrote:
>
> > Oracle PL/SQL stored procedures can return user-defined records and also
> > rowtypes. Where will you be returning the data to ? Is the calling
> > program also an Oracle stored procedure ?
> >
> > Vjacheslav Saiko wrote:
> >
> > > Hi all !
> > >
> > > Is it possible to return recordset from oracle stored procedure ?
> > > Something like :
> > >
> > > "select ID,NAME from TABLE1 "
> > >
> > > inside stored procedure ...
> > >
> > > Thanks for help.
Received on Thu Oct 02 1997 - 00:00:00 CDT