Re: HELP: What do these ORA codes signify?

In article: <Pine.SUN.3.91.960117153615.11984A-100000_at_topdog.cs.umbc.edu> johng_at_cs.umbc.edu (John G. Chirapurath) writes:
>
> The problem is that during the process of logging these transactions, I
> get error messages in the following order which consequently blocks the
> insert into that particular table and also the subsequent update into the
> overview table.
>
> ORA-00604 - error occurrred at recursive SQL level 1.
> ORA-01000 - maximum open cursors exceeded.
>
> I do not understand the reasons for these errors especially since I close
> both the explicit cursors which I use in the PL/SQL block controlling the
> insert/update processes.
>

First, check that you *really* are closing the cursors that you use explicitly. Are you re-opening them inside a LOOP, for example.

Second, maybe the implicit cursors used by Oracle to maintain the application are the problem. If so, you will need to raise the OPEN_CURSORS parameter in INIT.ORA, then bounce the database.

HTH, Pete

-- 

------------------------------------------------------------------------
|  Peter Moore - Database Administrator - MAT Transport Ltd, London, UK
|  pt_at_chaff.demon.co.uk : +44 (171) 410 6373
|  "With a little study you'll go a long ways & I wish you'd start now!"