• Post Reply Bookmark Topic Watch Topic
  • New Topic

Refcursor vs Pl-SQL Object types

 
Pankaj Kumarkk
Ranch Hand
Posts: 112
  • 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?
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!