ORA-01000: maximum open cursors exceeded

Possible Fix :

1)Ensure Oracle 8.1.7 JDBC driver or a later version should be used

2)Java code can be checked for closure of ResultSet & Statement after the using this specific stored procedure

3) Increase the value of OPEN_CURSORS parameter in Oracle

Steps to fix:

1)Do static code check and all of the cursors/connections are closed properly in the java code

2) Ask DBA Team to check the value of OPEN_CURSORS parameter in Oracle and see whether the value is too less or not.

3)Further analysis is possible only if we are having details of all open cursors at the time of exception (DBA Team can provide the details of opened cursors)