Re: Returning rows from a stored procedure - how?

Andy Noble <andy_at_dataworkshop.demon.co.uk> wrote in article <Ey6a8BAa8QMzEwWG_at_dataworkshop.demon.co.uk>... <snip>
> 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.

One of the few things that really sucks on Oracle (besides the crappy client tools). With SQL Server a stored proc can be a simple SELECT SQL statement. You will have to return a SQL cursor as far as I know. The client probably will have to cycle thru the cursor to retrieve the rows.

-- 
regards,
Billy
vslabs_at_onwe.co.za        Verreynne Software Labs,  Johannesburg  Z.A.