Re: Stored Procedure Question
From: Raymond Allo <idefix_at_sydney.net>
Date: Fri, 25 Sep 1998 13:01:58 +1000
Message-ID: <360B07A6.D7BC5D62_at_sydney.net>
Date: Fri, 25 Sep 1998 13:01:58 +1000
Message-ID: <360B07A6.D7BC5D62_at_sydney.net>
Scott,
[Quoted] What I think you are getting at is that you write a store procedure and then you
[Quoted] use that stored procedure in your select clause.
That is not possible in Oracle. However you can write a stored procedure which
returns multiple rows
[Quoted] through a PL/SQL table, but you still need another procedure to handle that. You
[Quoted] can't access that set with a sql-statement.
Raymond
S Metro wrote:
> In MS SQL Server it is possible to write a stored procedure that consists of
> a SELECT statement that returns multiple rows.
>
> Is this possible in Oracle 7.3x?
>
> Thanks,
> Scott
> smetro_at_world.std.com
> (take out nospam if replying via email)
Received on Fri Sep 25 1998 - 05:01:58 CEST