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

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 Tue Sep 30 1997 - 00:00:00 CDT