Java developer said that when he run sql statement embeded with Java , he got the following error messages.
The sql statement is the very simple insert and update statement.
Ora - 01000
01000, 00000, "maximum open cursors exceeded"
"error occurred at recursive SQL level %s"
// *Cause: An error occurred while processing a recursive SQL statement
// (a statement applying to internal dictionary tables).
// *Action: If the situation described in the next error on the stack
// can be corrected, do so; otherwise contact Oracle Support.
I checked open_cursor parameter in init.ora file.
It wat set to 200. I think that It seems OK.
I issued the following query
select * from v$open_query and only returns 14 rows.
I don't know what to do except increase the open_cursor parameter. This will be the last choice since the production database(24*7).
What do you think about this?