aspose file tools
The moose likes JDBC and the fly likes Refcursor vs Pl-SQL Object types Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Refcursor vs Pl-SQL Object types" Watch "Refcursor vs Pl-SQL Object types" New topic
Author

Refcursor vs Pl-SQL Object types

Pankaj Kumarkk
Ranch Hand

Joined: Apr 17, 2011
Posts: 108
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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Refcursor vs Pl-SQL Object types
 
Similar Threads
REFCURSOR in getCursor CallableStatement
Stroed Procedure&PL/SQL
getting the resultset of a stored procedure?
Problem using Callable Statement
stored procedure giving me sql error