Re: Can a procedure contain only a SELECT statement?
From: Mladen Gogala <no_at_email.here.invalid>
Date: Fri, 19 Mar 2010 19:23:46 +0000 (UTC)
Message-ID: <pan.2010.03.19.19.23.46_at_email.here.invalid>
On Fri, 19 Mar 2010 11:51:59 -0700, Thomas Gagne wrote:
Date: Fri, 19 Mar 2010 19:23:46 +0000 (UTC)
Message-ID: <pan.2010.03.19.19.23.46_at_email.here.invalid>
On Fri, 19 Mar 2010 11:51:59 -0700, Thomas Gagne wrote:
> So is there a way to use packaged procedures to select data without
> using cursors? It would be great if I could use the same syntax inside
> SQLDeveloper as I might inside a program, and process the results
> similarly to how normal selects are handled.
No, it is not possible. Oracle does not support local temporary tables which are alternative to cursors in some other RDBMS systems.
-- http://mgogala.byethost5.comReceived on Fri Mar 19 2010 - 14:23:46 CDT