Re: Can a procedure contain only a SELECT statement?

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Thu, 18 Mar 2010 05:42:38 -0700 (PDT)
Message-ID: <6c6a71ac-6626-4b9b-ba40-2fe562617d55_at_r1g2000yqj.googlegroups.com>

On Mar 17, 9:53 pm, Thomas Gagne <TandGandGA..._at_gmail.com> wrote:

snip

# I'm looking around for Oracle 10g CREATE PROCEDURE syntax and looking
> for examples with simple SELECT statements inside.

Why exactly would you want to do that in the first place?

Have you looked at something like this? http://www.oradev.com/ref_cursor.jsp Received on Thu Mar 18 2010 - 07:42:38 CDT