The problem is because of the cursor was not closed properly and for performance optimization you can increase a open cursor limit ALTER SESSION SET open_cursors = <new_value>;