Re: ? Maximum Open Cursors Exceeded ?

Change the open_cursors in init.ora file for your database to a large value. Then restart the database with the value.

Alternatively explore the applcation if you are opening cursors in a loop if so
try to close the cursors and release the resources associated.

In Pro*C we have ORACA option RELEASE_CURSOR, explore if similar option is available with your tool.

Regards
Tarun
Matthew O'Byrne wrote in message <3549A287.51BC_at_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 Sat May 09 1998 - 01:53:38 CDT