Re: Can a procedure contain only a SELECT statement?

From: John Hurley <>
Date: Sun, 21 Mar 2010 04:33:16 -0700 (PDT)
Message-ID: <>

On Mar 21, 7:21 am, Thomas Gagne <> wrote:


> > The fact that a procedure can also return a resultset doesn't really fit
> > the model of what a procedure is intended for.
> Can you elaborate on "... what a procedure is intended for?"

Really please take the time to buy and read a couple of Tom Kyte's books. It would probably be a better use of your time and you would have something permanent.

The first thing you need to understand is that you want to harness the power of Oracle not do things in some kind of database neutral type of interfacing.

Start by tossing out all your preconceived ideas of how you would do it in some other environment.

Good luck! Received on Sun Mar 21 2010 - 06:33:16 CDT

Original text of this message