Re: Can a procedure contain only a SELECT statement?

From: John Hurley <>
Date: Fri, 26 Mar 2010 15:33:59 -0700 (PDT)
Message-ID: <>

On Mar 26, 5:10 pm, "Jonathan Lewis" <> wrote:


> Thanks for that.
> I think your comments match the degree of complexity that I had
> thought might be necessary.  I wonder if this means that people
> tend to write "simple" procedures that only output one type of
> record set, rather than the multiple types that the OP was asking
> about.

I have a funny feeling the OP may not be answering these questions.

It is easy asking why Oracle doesn't have something that a different database apparently has. It gets more involved showing how exactly one would use those strange features in a practical manner.

Maybe those types of procedures in SQL Server are used in some batch manner and are just putting out data. In that case maybe the OP does not understand the spool command in sqlplus? Received on Fri Mar 26 2010 - 17:33:59 CDT

Original text of this message