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?