Getting a ResultSet/RefCursor over a database link
- by JonathanJ
From the answers to http://stackoverflow.com/questions/1122175/calling-a-stored-proc-over-a-dblink it seems that it is not possible to call a stored procedure and get the ResultSet/RefCursor back if you are making the SP call across a remote DB link. We are also using Oracle 10g.
We can successfully get single value results across the link, and…