sys_refcursor and Global Temp Table
I have a stored proc that returns a sys_refcursor that is a query from the Global Temporary Table. The problem is that I cannot get ODP.Net to return the results. It comes back empty every time.
The GTT is set for preserve on commit but ultimately I want to have it set to delete.
Does anyone have any experience with this and is willing to share some sample code for getting the values back from the stored proc?