This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Refcursor vs Pl-SQL Object types

 
Pankaj Kumarkk
Ranch Hand
Posts: 112
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
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 agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic