| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC - ERROR: ORA-01000
I have had this problem and it was down to the mis-placement of
a prepareCall() method inside a loop. Each time you execute
this method it seems to create another cursor.
Maybe this could be your problem.
Regards
Gary Smith
rogueharp_at_my-dejanews.com wrote:
> 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
--
 |
 |