Re: MAX CURSORS IN REPORTS 6.0

In article <954274383.28301.1.pluto.d4ee154e_at_news.demon.nl>, [Quoted] "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
>
> <jehall_at_my-deja.com> wrote in message
news:8br2kd$lsd$1_at_nnrp1.deja.com...
> > Hi. I have a very complex report that has tons of Column Functions
that
> > do SELECT INTO's etc...I know that with this statement an explicit
> > cursor is openend behind the screen. If I try to add any more CF, I
get
> > an error message stating that there are too many cursors open!!! Is
> > there a way I can free up the cursor after each SELECT INTO? I know
> > there is a close, but what is the implicit cursor name - Please
Help!!!
> >
> > Thanks.
> >
> > Jason.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> Increase the init.ora parameter open_cursors and bounce the database ,
there
> is NO way to close an implicit cursor, and AFAIK Oracle takes care of
that
> automatically.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
How do you do that??? Where do I go?

Jason.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 29 2000 - 15:39:28 CEST