wood burning stoves
The moose likes JDBC and Relational Databases and the fly likes Refcursor vs Pl-SQL Object types Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Refcursor vs Pl-SQL Object types" Watch "Refcursor vs Pl-SQL Object types" New topic

Refcursor vs Pl-SQL Object types

Pankaj Kumarkk
Ranch Hand

Joined: Apr 17, 2011
Posts: 110
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
subject: Refcursor vs Pl-SQL Object types
It's not a secret anymore!