> You can add the line OPEN_CURSORS=2000 to your initSID.ora file to
> increase the number of cursors you can open at any one time.
>
> Does anyone know if a cursor that has been opened during a proc. is
> not closed properly, does this leave a handle open? Or are all cursors
> closed implicity at an END; ?
>
As I know, the cursors are cached, and therefore it will be reused for the
procedure. All cursors will be closed after disconnect.
--
Regards
Nicolas Bronke
Received on Tue Nov 16 1999 - 14:59:48 CST
