OMG: an Oracle Question :)

Hello...

I have a small Oracle question... *ducks*

In SQL-Server I can return more then one resultset in a single stored Procedure (Get Parents and all child Objects for that/those parent(s))... Is the same possible in Oracle? I think I remember that Oracle cant do that due to the different handling of Selects in SPs?

Thats it...

Also I want to know if there is a reverse Copy of the Book ""SQL Server 2000 for the Oracle DBA"

Oracle allows you to return one or more results via REF CURSOR parameters from functions/procedures. These are more powerful than just returning results. For example, you can pass REF CURSOR parameter from one procedure to another.