Re: Stored Procedure Question
From: S Metro <smetro_at_nospam.world.std.com>
Date: Fri, 25 Sep 1998 11:47:20 GMT
Message-ID: <Ezu8t4.Bq1_at_world.std.com>
Date: Fri, 25 Sep 1998 11:47:20 GMT
Message-ID: <Ezu8t4.Bq1_at_world.std.com>
[Quoted] Actually, what I want to do is write a stored procedure like this:
create procedure sp_myproc as
select city, state, zip from info_table;
Can that be done in Oracle, because it can in MS SQL Server?
-- smetro_at_world.std.com (take out nospam if replying via email) Raymond Allo wrote in message <360B07A6.D7BC5D62_at_sydney.net>...Received on Fri Sep 25 1998 - 13:47:20 CEST
>Scott,
>
>What I think you are getting at is that you write a store procedure and
then you
>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
>through a PL/SQL table, but you still need another procedure to handle
that. You
>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)
>
>
>