Yes, if you are using 7.2 or higher you can use "REF CURSOR", which enable you to return a result set.

For detailed explanation and various examples see [url]http://osi.oracle.com/~tkyte/ResultSets/index.html[/url]

HTH,