Hi,


When we calling the stored procedure from front end screen, we are facing the below errors accordingly

"
UNSUCCESSFUL EXECUTION CAUSED BY A SYSTEM ERROR THAT DOES NOT PRECLUDE THE SUCCESSFUL EXECUTION OF SUBSEQUENT SQL STATEMENTS. SQLCODE=-901, SQLSTATE=58004, DRIVER=4.11.77 DSRA0010E: SQL State = 58004, Error Code = -901
com.ibm.websphere.ce.cm.StaleConnectionException: UNSUCCESSFUL EXECUTION CAUSED BY A SYSTEM ERROR THAT DOES NOT PRECLUDE THE SUCCESSFUL EXECUTION OF SUBSEQUENT SQL STATEMENTS. SQLCODE=-901, SQLSTATE=58004, DRIVER=4.11.77 DSRA0010E: SQL State = 58004, Error Code = -901
"

or

"Caused by: java.sql.SQLNonTransientException: [jcc][t4][10335][10366][4.11.77] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003 DSRA0010E: SQL State = 08003, Error Code = -4,470
... 39 more
.


"
DB2 v 9.5 z/os

The stored proc is having the SELECT query only..

Please help