Re: Unable to validate/drop object

The function must be calling a different function which in turn calls the initial function. Try dropping any dependent procedures first. They are listed in user_dependencies.

Hth,

Sybrand Bakker, Oracle DBA

"Raamsdonk J. van" <J.van.Raamsdonk_at_centraal.boekhuis.nl> wrote in message news:78CC0C89B41DD311B8900000F6CB6A8E0CDD88_at_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 - 14:20:46 CST