Re: ORA-01000: maximum open cursors exceeded

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 18 Oct 2004 21:30:59 -0700
Message-ID: <1098160208.601210@yasure>

vinnie washington wrote:

> I'm wondering if anyone can help me figure out why I'm receiving this
> problem. I am running Oracle 8.1.7 on Win2K server and have been
> receiving this message in my application. When I query 'select
> sql_text from v$open_cursor; ' to see what is holding things up, I
> see:
>
> SELECT NULL AS table_cat, t.owner AS table_schem,
>
> with 300 entries in the table. Any thoughts?

Not using bind variables?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Mon Oct 18 2004 - 23:30:59 CDT