Re: MAX CURSORS IN REPORTS 6.0
Date: Tue, 28 Mar 2000 22:12:21 +0200
Message-ID: <954274383.28301.1.pluto.d4ee154e_at_news.demon.nl>
<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 [Quoted] is NO way to close an implicit cursor, and AFAIK Oracle takes care of that automatically.
[Quoted] Hth,
Sybrand Bakker, Oracle DBA Received on Tue Mar 28 2000 - 22:12:21 CEST