Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help ! Opened cursors exceed max opened cursors
We had the same problem. I added a line in the initorcl.ora file :
OPEN_CURSORS=100.
The default is 50, so the increase took care of our problem.
rhawkins_at_comptek.nospam.com
Vincent Leung wrote in message <348703EA.AE1509E3_at_ix.netcomc.com>...
Hi folks,
We use Oracle as Database source to store and maintain our data and use Microsoft MFC interface to connect Oracle and fetch data. After we ran our application for about an hour or so, we can not insert or update our data to the database anymore. We trace the problem using SQLGetDiagRec which MFC provides. It showed us that opened cursors exceed max opened cursors. Here is the procedure to retrieve data .
We tested the database and saw the table has new inserted data or updated data there until the cursors error appeared. I understand that the function SQLFreeStmt with SQL_CLOSE and SQL_UNBIND can help us to close cursor that has beeen opened after SQLPrepare is called. Have I misused these database interface which MFC provides?.
We will really appreciate if any one can give us any help on this. Thanks in advance.
Yan Wang
Phasemetrice, Inc.
Received on Fri Dec 05 1997 - 00:00:00 CST