Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

what is REF Cursor in oracle ??

 
Raj Sikka
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 145
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic