In our application, a oracle SP was written using 'Ref' cursor.Then the same SP will be invoked by a JSP script .
Is there any advantage of using 'Ref' cursor over the normal cursor?
Which cursor will give me the optimal performance?
Can the 'cursor For Loops' improve the performance of the SP?

01-17-2003, 05:22 AM

Sameer

One of the advantage of REF CURSOR is, you can use defined CURSOR type variable to open a new cursor after closing the previous. So by saving multiple CURSOR definations in DECLARATION. Using REF CURSOR you can also define multiple cursor variables, if you need to open multiple cursors at a time