Re: Returning rows from a stored procedure - how?

Andy Noble <andy_at_dataworkshop.demon.co.uk> wrote:

> However I cannot find ANY documentation telling me how to
> return a result set from a SELECT statement back to the
> front end application. I can only find comments that it is
> possible.

        You haven't found any documentation about result sets in functions or storage procedures because IT'S NOT POSSIBLE!

        I think that Oracle8 may be capable of doing this (as Microsoft SQL Server is...)

        There's some ways (no one easy or transparent) to do this. You can use a pipe in the storage procedure to send data to application program, before the procedure returns. You can write the result set to some temporary table and allows the application program to select from it and so on...

        Regards,

--
Luis Santos
Relacional Consultoria
Rio de Janeiro - Brazil