Re: Returning a result set from a table using a stored procedure

Look at using reference cursors (and binding the cursor to your host programming lang.).

SCott
Hive Software, Inc.

Ajay Soni wrote:

> Hi,
>
> We're trying to return a table by calling a stored procedure which has a
> select clause inside ( which looks like SELECT * FROM MYCUSTOMERS ).
>
> Example:
>
> >EXECUTE GET_CUSTOMERS
>
> Returns:
>
> Surname Firstname Address
> ---------------------------------------------------------------------
> Smith John 123 Broadway
>
> We know it's possible to do it in MSQL Server, but how can it be done in
> Oracle 7.x
>
> Cheers
>
> Ajay
Received on Mon Jul 06 1998 - 11:58:20 CDT