aspose 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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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 ??
 
Similar Threads
Invoking a Oracle Stored Proc which takes a REF CURSOR as a IN parameter
what is ref cursor?
Cannot get Oracle CURSOR from Oracle procedure
Closing cursor in a stored procedure when invoked from a callable statement
Registering IN OUT parameter