Re: JDBC problem
From: <sybrandb_at_my-deja.com>
Date: Mon, 05 Feb 2001 12:55:38 GMT
Message-ID: <95m7s7$l0u$1_at_nnrp1.deja.com>
Date: Mon, 05 Feb 2001 12:55:38 GMT
Message-ID: <95m7s7$l0u$1_at_nnrp1.deja.com>
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 - 13:55:38 CET