Dear All,
First of all, i'm indonesian..i'm sorry if i don't speak English correctly
i am a technical consultant in a fully web-based application for HR Modules. We're running a project in a company who run Oracle 10g as their database.
Previously, we have ran this application at another company using SQLServer and MySQL DB, and had no problem.
So i assume, java programming for this web based application is effective, because SQLServer didn't consume much memory. For comparison, SQLServer is able to process 6000rows without errors.
But when we run the same process in Oracle, with lesser data (only 240 data), we found error ORA-01000 maximum open cursors exceeded
I try to expand open_cursors to 3000, but error still occured.
Please help..any idea?
I have read previous thread about this also..someone said that setting open_cursors to 300 is big enough for application..then what's wrong with this?

Thank you very much in advance