Re: Forms: Too Many Cursors

In article <3A3762CB.29AB_at_yahoo.com>,
  connor_mcdonald_at_yahoo.com wrote:
> challinj wrote:
> >
> > I am basing Oracle Forms data blocks on procedures that return REF
> > CURSORs to the client. It appears that the cursors are opened on
 the
> > server and never closed after they are used to retrieve the data for
> > the Oracle Form. It is just a matter of time before "ORA-01000 Too
> > Many Open Cursors" rears its ugly head and no further querying for
 the
> > user is possible. The OPEN_CURSORS parameter in INIT.ORA is 50.
> >
> > I initially had my forms based on PL/SQL tables and thought that it
> > would be a nice exercise to try REF CURSORs instead. Too bad that
> > Oracle documentation failed to mention that any cursors opened on
 the
> > server in my packages will remain open indefinitely. It would be
 nice
> > if Oracle Forms could automatically close the REF CURSORs on the
 server
> > for me once the data has been retrieved. Is there any other option
> > other than raising the OPEN_CURSORS param to a high number? I've
> > noticed that others have had similar problems with Java resultsets,
 etc.
> >
> > Any help or input on this subject would be greatly appreciated.
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
> The database default (of 50) is miniscule...Bump it up to 1000 (Forms
 is
> notorious for keeping many cursors open)
>
> HTH
>
> "Some days you're the pigeon, some days you're the statue"
>

THANKS FOR THE ADVICE. I'LL TRY THAT IF I CAN GET THE DBA'S TO AGREE TO IT.

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 13 2000 - 14:44:37 CST