how to returning a recordset

[kquintero]

hi people
I'm translating lots of SQL stored procedures to Oracle procedures. In SQL I can create cursors as easy as:
CREATE PROCEDURE myprocedure AS
SELECT * FROM mytable1
SELECT * FROM mytable2

this procedure creates 2 cursors that later will be converted to recordsets in client machine with ADO objects. How can I do same thing in Oracle?

TIA
Karen

[debasisdas]

Please find a related article here.

[Saii]

you have to explicitly write "cursor <CUR_NAME> is select * from <table>" in Oracle

[amitpatel66]

You can also check for REF CURSORS.