Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00604 error occured at recursive SQL Level 1
Brian
Try to increase OPEN_CURSORS parameter in the initSID.ora file. By default, OPEN_CURSORS = 50 - this is very small.
Brian Drust <drusty_at_ix.netcom.com> çàïèñàíî â ñòàòüþ
<340CC9DA.AEAD0C30_at_ix.netcom.com>...
> I hope someone can shed a little light on the following error
> message ORA-00604 error occurred at recursive SQL Level 1 ORA-01000
> Maximum open cursors exceeded.
>
> This seems pretty straight forward but I can not figure it out. When I
> look up the ORA-00604 it tells the next error on the stack can't be
> resolved then call tech support. Ya that really helps allot. Maybe
> that is part of my problem. The maximum number of cursors open seems
> easy. The only thing the code contains no explicit cursors only
> straight SELECTS, INSERTS, and UPDATES. This error always seems to
> happen in the same place also. The program is written in ProC. Nothing
> fancy and rather small. I am running on a HP-UNIX system with Oracle
> version 7.2.?.? or something. If anyone has any ideas or needs more
> info please E-Mail at drusty_at_ix.netcom.com.
>
>
Received on Fri Sep 05 1997 - 00:00:00 CDT