Data Boy wrote:Nothing.
What is the best of returning result set without using REF CURSORS.
Data Boy wrote:No you cannot. You may think this is a solution. It is not. It can degrade the entire server's performance to such an extent that CPU time is spend mostly on swapping virtual pages between swap space and physical memory.
i beat my bench to find out the alternative way of getting the same result.
I can do with function.