In the initSID.ora file, add the line "OPEN_CURSORS" = 50 and
restart the database.
Joe
Matthew O'Byrne wrote:
>
> 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 - 08:14:07 CDT
