Re: Oracle's ? = SQL Server's stored procedure ???

From: Rob Calfee <trace_at_primenet.com>
Date: 2000/03/06
Message-ID: <8a0lud$is3$1@nnrp02.primenet.com>#1/1

Yes, You can use cursors to create more than one recordset. Although, to give an explanation is beyond the scope of this message. Check out Steve Feuerstein's Oracle PL/SQL Programming for more details or consult your online doc.

Rob Calfee
Systems Consultant
Quest Software
rcalfee_at_quest.com

xiaomh <xiaomh_at_hotmail.com> wrote in message news:8a0ep5$91a$1_at_news.gov.on.ca...
> Does anyone know what's the simliar object in Oracle to stored procedure
in
> SQL Server,
> I mean:
> In SQL Server, you can get two recoredset in one stored procedure, for
> example:
> create procedure myTest
> as
> select * from jobs
> select * from employees
>
> How can I do this in Oracle? It seems to me in Oracle's stored procedure,
I
> can only use DELETE, UPDATE or INSERT. Should I use CURSOR to realize this
> purpose?
>
> Thanks in advance.
>
>
>
>
Received on Mon Mar 06 2000 - 00:00:00 CST