Maximum cursor exceeds ORA-01000: maximum open cursors exceeded [SWF-1760]

[spring-operator]

Anuj Sharma opened SWF-1760 and commented

I am using Spring Boot and Store proc call.

When we query for bulk data GET call then a stored proc gets called and it returns a cursor.

after sometime over server we face the issue as below:   ORA-01000: maximum open cursors exceeded

we have OPEN_CURSORS configured at DB side( oracle) 300.

We are using SimpleJdbcCall.

Kindly address the issue.

---

No further details from SWF-1760

[spring-operator]

Rossen Stoyanchev commented

Could you clarify how is this related to Spring Web Flow?