Hello,
I am new to oracle development. I have a stored procedure that used to output it's content to a file. I need to convert this proc to output an in memory or temp table which will then be consumed via a .net app to display the results on a web form.
I have read that you generally don't have to do this very often however however in my case the procedure does some heavy data manipulation. can one give me an example of creating a virtual table to output the results to a refcursor?
Thanks for the assistance.