Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC - ERROR: ORA-01000

Re: JDBC - ERROR: ORA-01000

From: <rogueharp_at_my-dejanews.com>
Date: Mon, 15 Jun 1998 19:55:03 GMT
Message-ID: <6m3u6n$ces$1@nnrp1.dejanews.com>


In article <356757C4.E6B9E5AE_at_cgocable.net>,   Alan Campbell <ajc_at_cgocable.net> wrote:

>

> There is an init.ora parameter OPEN_CURSORS or MAX_OPEN_CURSORS that you need
> to increase to a larger value and then restart the Oracle Instance.

We have this same problem, and have set the parameter to 7000 (overkill) and we still get this error. If we wait a bit after the error, then the code will work. It appears that some garbage collection routine isn't working correctly, or in a timely manner.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 15 1998 - 14:55:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US