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

You can try to store the result from the SELECT statments into variables and then use dbms.put_line ('variable')
to print the output to screen.

Winnie

Ajay Soni wrote in message <01bda8f6$921f7c00$9a6adec2_at_ajaytosh>...
>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 - 22:04:35 CDT