I am facing a issue while calling a stored procedure using execute stored proced

Make sure you are handling your resultset and statements properly and that you are closing them:
stackoverflow.com/.../ora-01000-maximum-open-cursors-exceeded-java-code-fails

Are you using the latest version of the Execute Stored Procedure plugin? There was a change made on version 1.0.8 that resolved a case where an error would stop the database connection being returned to the pool which will result in the connection pool maxing out.

Hi Tim, We are using version 1.0.8 for Execute stored procedure node but still facing the issue.

Version 1.0.8 has a fix that prevents an edge case where the connections are not properly returning and causing the connection pools to eventually run out and reach max open cursors limit. However, in order to remedy the "ORA-01000: maximum open cursors exceeded" error, a restart of the application server is necessary to free up the connection cursors.

Hi Tim, if this issue is occurring frequently than its not good to restart application server every time. Is there any pointer where problem can exists? If we analyse the scenario which Sunny has mentioned, following comes into picture:
1. Smart Service
2. Stored Procedure in DB.
where this leak can be?

Please check all custom plugins to insure that connections are are being properly handled.