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

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