Oracle Error ORA-24410: scrollable cursor max size exceeded

Oracle Error Message

ORA-24410: scrollable cursor max size exceeded

Reason for the Error

Result set size exceeded the max limits.

Solution

Check the documentation for allowable maximum result set size for scrollable cursors. Re-execute with a smaller expected result set size or make the cursor non-scrollable.