Return values as Out Parameters or as ResultSet return value?

If you'd like a stored procedure to return a value, what's the difference between returning it as an out parameter (SELECT returnValue INTO outParameter ...) or as the ResultSet of the stored procedure (SELECT returnValue ...)

In either case, the value you need is returned correctly. Are there any implications with regards to style, performance, or other characteristics that I should keep in mind when deciding which strategy to adopt?

Thanks.

[467 byte] By [lightbulb4321a] at [2007-11-27 6:32:46]