IntelliJ Java IDE
The moose likes Oracle/OAS and the fly likes What is the advantage of using Ref Cursors over Normal cursor in pl/sql block Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Reply Bookmark "What is the advantage of using Ref Cursors over Normal cursor in pl/sql block" Watch "What is the advantage of using Ref Cursors over Normal cursor in pl/sql block" New topic
Author

What is the advantage of using Ref Cursors over Normal cursor in pl/sql block

Mrutyunjay Hanchinal
Ranch Hand

Joined: Sep 26, 2001
Posts: 50
Hi,
I want to know What is the advantage of using Ref Cursors over Normal cursor in pl/sql stored procedures?
I have heard that it is having more of dis- advantages than advantages Is that true?
Please let me know any good online resource that will elaborate on this.
Thanks,
Mrutyunjay.
-----------
 
 
subject: What is the advantage of using Ref Cursors over Normal cursor in pl/sql block
 
Threads others viewed
Java Stored Procedure in SQL Server
Closing cursor in a stored procedure when invoked from a callable statement
Get ResultSet by executing anonymous pl/sql block.
what is ref cursor?
Execution of stored procedure using for loop
MyEclipse, The Clear Choice

cast iron skillet 49er

more from paul wheaton's glorious empire of web junk: cast iron skillet diatomaceous earth rocket mass heater sepp holzer raised garden beds raising chickens lawn care CFL flea control missoula heat permaculture