Cursors within Cursors - is it possible?

[Quoted] I have two tables (Order and OrderItems). I would like to create a procedure [Quoted] that returns back all Orders and for each Order, all of its items.

[Quoted] Is it possible to create a procedure that returns a REF CURSOR that has a [Quoted] cursor within itself?

So, it would be something like:

...

TYPE testCursor is REF CURSOR;
...

BEGIN
    OPEN testCursor FOR
    SELECT order_id, order_date
    FROM ORDER;
END;
...

How can I also get a cursor or items within that order for each order? I have tried many different guesses, but none will compile.

Any help is greatly appreciated.

--

Thanks.

Patrick Casey