Re: Can a procedure contain only a SELECT statement?

My background is Sybase & SqlServer. On both, due I'm sure to a common heritage, a stored procedure is capable of being as simple or complex as the programmer wants. Sometimes, all that is needed is a select statement. Sometimes even simple projections may require multiple steps to prepare the last SELECT. Additionally, stored procedures are capable of returning multiple result sets. I assumed, incorrectly, such a thing was not so complicated that it couldn't be easily done inside Oracle.

I'm curious about packages and the procedures inside them. I take it the cursor must be treated as a cursor inside the application rather than as a result set? I'm using .Net, OracleDataAdapter, and DataSet. It seems as though result sets from stored procedures will require something else. Received on Thu Mar 18 2010 - 21:26:44 CDT