I would like to know scenario where Refcursor should be preferred over PL-SQL objects as stored procedure return types.
I have been using PL-SQL objects till now. I have come to know that using refcursor, the stored procedure programming becomes very simple. I would like to know what are the pros/cons of using Refcursor in java.
In what scenario we should never use refcursor?
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com