Hi, Does anyone can tell me if Oracle can return a Result Set or Record Set from a PL/SQL block ?
It is better to ask and appear ignorant, than to remain silent and remain ignorant. Oracle OCP DBA 9i, C++, Java developer
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,
Jurij Modic ASCII a stupid question, get a stupid ANSI 24 hours in a day .... 24 beer in a case .... coincidence?
Forum Rules