? 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