It's not a secret anymore!
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "what is REF Cursor in oracle ??" Watch "what is REF Cursor in oracle ??" New topic

what is REF Cursor in oracle ??

Raj Sikka
Ranch Hand

Joined: Apr 11, 2003
Posts: 34
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 ,
Sujatha Ranganathan

Joined: May 29, 2003
Posts: 12
Hi Srikanth,
You will find documentation on Oracle Ref Cursor hereOracle JDBC Developer's Guide
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.
I agree. Here's the link:
subject: what is REF Cursor in oracle ??
It's not a secret anymore!