Well having worked on both SQL Server and Oracle (although not the latest version of oracle) let me clear the air on
thedifferences between the two as far as stored procs are concerned.
On SQL Server you can return many result sets.
On Oracle, you can't. The best thing you can do is return arrays as parameters and simulate a result set by populating
thatarray row by row (SLOW). I think in most situations, you'll see people just running a select statement from the
clientside whenever possible.
I much prefer working in Sybase and SQL Server because of the ability to return multiple result sets.
Roy.