Executing Stored Procedures
I am currently using Sybase/db-lib and I routinely execute
stored procs that return multiple (different) result sets. I know
Informix is limited to one result set per stored procedure. Does anyone
know if this is also true in Oracle. An example of a stored procedure is
as follows:
create procedure test1
@arg1 int,
@arg2 floatas
select
col1,
col2
from
table1
where
col3 = @arg1
select
col4,
col5
from
table2
where
col6 = @arg2
go
NOTE: the datatypes of the results do not need to be defined and can be
different within the 2 result sets.
Michael Gallagher
Open Link Financial
Email: mgallagh@olf.com
Phone: (516) 227-6600 x212