Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: JDBC problem
In article <3A7E93AD.2F0D13F8_at_cs.strath.ac.uk>,
Randeep Gill CS1997 <rgill_at_cs.strath.ac.uk> wrote:
> I am using JDBC to access an oracle 7 database however keep
experiencing
> the following AQL error: The ERROR : ORA-01000: maximum open cursors
> exceeded
> Ive tried closing all my resultsets after use but that doesnt help.
> Any ideas?
>
Increase the init.ora parameter open_cursors. The default is 50 which
is just ridiculous.
Hth,
-- Sybrand Bakker, Oracle DBA All standard disclaimers apply ------------------------------------------------------------------------ Sent via Deja.com http://www.deja.com/Received on Mon Feb 05 2001 - 06:55:38 CST