Re: NEWBIE: converting MSSQL to oracle

VC wrote:
> Hello,
>
> Why not just use a reference cursor ??? Seems much simpler ...

Simpler does not necessarily mean better when once considers the implications on performance, scalability, and resources such as latches.

But it is certainly something that should be explored.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)