Re: 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 NOT! check the WITH RESUME syntax for stored procedures. } know if this is also true in Oracle. An example of a stored procedure is } as follows: } } create procedure test1 } @arg1 int, } @arg2 float } as } 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 } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net