Hi,
Does anyone can tell me if Oracle can return a Result Set or Record Set from a PL/SQL block ?
Printable View
Hi,
Does anyone can tell me if Oracle can return a Result Set or Record Set from a PL/SQL block ?
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 http://osi.oracle.com/~tkyte/ResultSets/index.html
HTH,