So what happens when you issue the 2 selects from within a stored proc? Say
you want to pass an account number to a stored procedure that pulls info
from a customer, orders and product table. How would you do this?
Billy Verreynne wrote in message <6gi9se$om7$1_at_hermes.is.co.za>...
>Jeff wrote in message <6ggef6$s0m$1_at_usenet54.supernews.com>...
>>Was wondering if Oracle supports multiple result sets? Can I pass an
>>account number to a stored procedure, then select * from a customer table,
>>then select * from an orders table. What I'm trying to do is pass an
>>account number and pull the info from the customer and orders table.
>
>
>Not sure what you mean with "multiple result sets". The SQL language does
>not support "multiple data sets" resulting from a single SQL statement.
>
>Multiple data sets (or tables) can be combined with a JOIN. In this case
>every invoice row will also contain all the columns from the customer
table.
>
>Another way to combine more than one data set into a single result set via
>SQL is to UNION the SELECTs. This will however only work if the number of
>columns and datatypes correspond between the SELECTs sets.
>
>What is wrong using two seperate SQL statements, one to supply info from
the
>customer table and one to supply the invoices? I fail to see any real
>technical requirement for trying to do it as a single result set via a
>stored procedure.
>
>regards,
>Billy
>
>
>
Received on Thu Apr 09 1998 - 08:22:52 CDT
