Re: Stored Procedure Question?

A lot of us are using Oracle because we have to - not because we want to. Some higher-up type figured out that Oracle is #1 so they wouldn't get fired for choosing it. We may be used to using things like temporary tables and having a SELECT at the end of a stored procedure to conveniently generate output.

We *are* trying to figure out how to do these things in Oracle using the database the way it was designed. But sometimes it's a very difficult task (as it would be for someone who was used to using Oracle and then had to switch to SQL Server).

Bob Malos
bob.malos_at_csu.mnscu.edu

"Daniel A. Morgan" wrote:

> You can. But you would accomplish absolutely nothing. If you do not select
> your result into something then it is sort of like asking what is the sound
> made by a tree falling in the forest is no one is there to hear it?
>
> This has been said before in this forum and it bears repeating. Oracle is
> not SQL Server, or Sybase, or Informix, or whatever ... it is Oracle. And if
> you want to use the tool you need to learn to use it the way it was designed
> to be used. Certainly it is not that big an imposition to write "FROM DUAL".
> Though why you wouldn't use a cursor is beyond me.
>
> Daniel A. Morgan
>
> Ray Vonhollen wrote:
>
> > This is probably a simple question but, Can an Oracle's Stored Procedure
> > use a simple internal select statement, without the necessity of having
> > to prototype an out parameter in the stored procedure itself?
> >
> > As is common with MSSQL & Sybase, one can simply issue an internal
> > Select statement within the stored procedure such as: Select Mycol from
> > Mytable.
> >
> > I find, with my limited knowledge in Oracle, that one would have to
> > perform a Select Mycol into MyNewCol from Dual;. Is there any
> > workaround on this to simply cause a select statement to be performed?
> >
> > Any advice or simply example would be greatly appreciated.
> >
> > R-
Received on Tue Apr 10 2001 - 20:46:00 CEST