Unable to validate/drop object

From: Raamsdonk J. van <J.van.Raamsdonk_at_centraal.boekhuis.nl>
Date: Tue, 12 Dec 2000 16:08:44 +0100
Message-ID: <78CC0C89B41DD311B8900000F6CB6A8E0CDD88@srvexch1.centraal.boekhuis.nl>

Hi all,

A developer managed to create a function in PL/SQL that is now impossible to validate/drop. When tried, it returns the following error-mssgs;

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded

The problem is not the cursors - only one cursor is opened in this function. The problem is referenced on Metalink as a "circular reference in the SYS.DEPENDENCY$ table for the object. I experimented a bit on a test-database with removing suspected rows from DEPENDENCY$ but that only shifted the problem one level higher to an object that had a dependency pointing towards the first object. What may be happening is that there exists a circular reference that spans more objects (one points to two which points to three which points to one). But it baffles me how to solve this.

Anyone? :-)

Jos van Raamsdonk
DBA
Centraal Boekhuis BV
Culemborg
Netherlands. Received on Tue Dec 12 2000 - 09:08:44 CST