Re: Too many cursors

Thank you, I know about open cursors. Why am I getting the error only when I run the procedure through a trigger and not when I simply execute it?

Van

"Hermann Schlösser" <hs_at_technologist.com> wrote in message news:9044nf$rji$05$1_at_news.t-online.com... Van Messner wrote:

> But this generates an ORA-01000 too many cursors error.
> Any suggestions, remedies or clues?

from the 8.1.6 Docs, Initialisation Parameters if not set otherwise in initSID.ora, it defaults to 50

OPEN_CURSORS specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once. You can use this parameter to prevent a session from opening an excessive number of cursors. This parameter also constrains the size of the PL/SQL cursor cache which PL/SQL uses to avoid having to reparse as statements are reexecuted by a user.
It is important to set the value of OPEN_CURSORS high enough to prevent your application from running out of open cursors. The number will vary from one application to another. Assuming that a session does not open the number of cursors specified by OPEN_CURSORS, there is no added overhead to setting this value higher than actually needed.

have fun
Hermann Received on Wed Nov 29 2000 - 18:12:21 CST