I'm getting an Open Cursor exeeded error while running our application.
The server Oracle is 8.17 version, the o.s. is Linux. The C++ code is running some SQLs, using OCI. The queries don't use bind variables, but they are parsed and the values are substituted before they run on the Oracle server.
I've seen the message recently posted by sunilthomas98, but the thread doesn't solve my problem: I never open explicit cursors, but every time I run a query I suppose Oracle open an implicit cursor. After a lot of operations, the number of open cursors go over the max value.
Is there some way to make Oracle close those cursors?
When I tried to run the same application on 9i Oracle version, I have no error, and the opend cursors are always a few.