File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes what is REF Cursor in oracle ?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "what is REF Cursor in oracle ??" Watch "what is REF Cursor in oracle ??" New topic
Author

what is REF Cursor in oracle ??

Raj Sikka
Ranch Hand

Joined: Apr 11, 2003
Posts: 34
Hi,
What is REF Cursor in oracle ?
What are differences bt ordinary oracle cursor and a
REF Cursor ?
Is it necessary to close REF cursor explicitly ?
Is there any good documents about REF Cursors and their usage ?
Pls help me out .
Thanks ,
Srikanth
Sujatha Ranganathan
Greenhorn

Joined: May 29, 2003
Posts: 12
Hi Srikanth,
You will find documentation on Oracle Ref Cursor hereOracle JDBC Developer's Guide
Sujatha.
http://otn.oracle.com/sample_code
Sandeep Ghosh
Ranch Hand

Joined: Jan 23, 2002
Posts: 145
Hi Srikanth,
As far my little knowledge goes, if you are calling stored procedure from JDBC and SP needs to return multiple rows then you can choose to return either nested table or ref cursor. Ref cursor has advantage that Oracle9i free the memory space when you close the statement.Unlike nested table which oracle keep in memory until you close the connection. If you are using connection pool then it will be a problem .
Correct me if I wrong.
Sonu
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: what is REF Cursor in oracle ??