Re: Stored Procedure Question

Hi scott,

Yes it is possible to return multiple rows from a stored procedure in Oracle 7.3x. Ref Cursors or Table of Records are the constructs which can be passed from and to, to the stored procedures.(This is Possible because of PL/SQL Ver 2.3 and heiger).

Regards,
Sandy.
SKhajuria_at_hotmail.com

In article <EztGKF.Muy_at_world.std.com>,   "S Metro" <smetro_at_nospam.world.std.com> 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)
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sun Sep 27 1998 - 14:09:25 CEST