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 .

1. get handle using SQLAllocHandle,
2. write a query statement
3. call SQLPrepare to prepare the query statement
4. call SQLExecute to execute query statm
5. Fetch the date using SQLFetch function
6. finally call SQLCloseCursor and SQLFreeStmt with SQL_CLOSE and SQLFreeStmt with SQL_UNBIND.

    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