Hi all,
I am developing a simple application using Developer2000/Oracle 7. This
application logs transactions based on 6 different categories and stores
it in 6 separate tables. There are six form interfaces to facilitate this
process. Also, whenever an insert occurs in any of these 6 tables a
value gets updated in an overview table which holds the aggregate of these
transactions.
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.
If any of can shed some light on this I would be most appreciative. In
particular can I handle the 'maximum open cursors' thing as an exception
or is there system variable corresponding to this that I can explicitly
reset.
Email me at johng_at_cs.umbc.edu or post to this group.
Best Regards,