URGENT!! Too many cursors open

[Kenia Nimesh]

In one of our program we are opening 3 ResultSet(cursors) at a given point of time.

The queries are retreving records from the database.If there are many records retreived we are getting the foll error.

 

java.sql.SQLException: ORA-01000: maximum open cursors exceeded We have Oracle 8.0.5 as our database.

The maximum OPEN_CURSORS set in init(DBinstance).ora is 120 still we are getting the error.

Please help me.

Thanks in advance

Nimesh