multiple select statements in stored procedures

[Xiangyang Liu]

With SQL server, it is easy to have multiple select statements in a stored procedure, the outputs for the select statements are just tables in the output data set. Is it possible to do this in Oracle? Thanks.

My Younger Son & His "PET"

[Pete OHanlon]

Yes. Have a look at this[^] thread to get some ideas.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

[Jorgen Andersson]

Here's[^] an example, scroll down to "Returning Results with Oracle REF CURSORs" The example is for a DataReader, but the same principle applies to a DataAdapter.

"When did ignorance become a point of view" - Dilbert

[Xiangyang Liu]

I looked at the link you provided: It is not the same thing. The solution provided requires two select statements to return the same number of columns and the column types have to match. While in SQL server, you can have an arbitrary number of select statements and arbitrary data types. I guess the answer to my question is NO. Thanks.

My Younger Son & His "PET"

[Xiangyang Liu]

That looks like a good solution. Thanks.

My Younger Son & His "PET"

[Jorgen Andersson]

You're welcome.

"When did ignorance become a point of view" - Dilbert