Neil Conway wrote:
On Fri, 2004-09-24 at 01:56, Joe Conway wrote:
As other's have pointed out, this is very common in the MS SQL Server world (and I believe Sysbase also supports it).
From looking at the docs, it appears this isn't supported by Oracle orDB2 (correct me if I'm wrong). I can see how it would be useful, but I don't think it needs to be part of the first shot at doing stored procedures.
For Oracle you would return refcursors...
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend