Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ? Maximum Open Cursors Exceeded ?

? Maximum Open Cursors Exceeded ?

From: Matthew O'Byrne <Iridium_at_netcomuk.co.uk>
Date: Fri, 01 May 1998 11:23:49 +0100
Message-ID: <3549A2B5.4980@netcomuk.co.uk>


Please help me with this error :

        [ODBC Driver Error] Maximum Open Cursors Exceeded

VB5(using RDO) extract follows ...

...

Global G_Ev As rdoEnvironment
...

    Set G_Ev = rdoEngine.rdoEnvironments(0)     G_Ev.CursorDriver = rdUseClientBatch ' updates work
...

Able to open 9 rdoResultsets in this manner :

   Set G_dbRBM = G_wsHelpDesk.OpenConnection("", , , G_sRBMConnect)
...

    Set M_tblRoomEquipment = G_dbRBM.OpenResultset("SELECT * FROM Room", rdOpenKeyset, rdConcurRowver)

    Set M_tbl2 = G_dbRBM.OpenResultset("SELECT * FROM Equipment", rdOpenKeyset, rdConcurRowver)
etc...

then on the 10th this error occurs :

        [ODBC Driver Error] Maximum Open Cursors Exceeded

Is this related to a parameter in the init.ora file ? That I should alter ? I need to be able to open around 20 resultsets. Received on Fri May 01 1998 - 05:23:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US