Re: Can a procedure contain only a SELECT statement?
Date: Thu, 18 Mar 2010 22:26:44 -0400
Thank you all for your help.
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