we are running a JDBC application and keep on getting this error: ORA-01000: maximum open cursors exceeded
We are not sure why we are getting it. We have noticed that it occurs after we have executed several sql statements. has anyone seen this. we are wondering if with JDBC you have to close statement clauses and resultset. we are currently only closing statements. does this ring a bell with anyone..??