Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Unable to validate/drop object
Tried that earlier - when trying to delete dependent objects, the same error-situation occurs.
I submitted the problem to OSN using Metalink - it was designated Tar 478116.55.
-----Oorspronkelijk bericht-----
Van: Sybrand Bakker [mailto:postbus_at_sybrandb.demon.nl]
Gepost om: dinsdag 12 december 2000 21:21
Gepost naar: misc
Discussie: Unable to validate/drop object
Onderwerp: 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.n
l...
> 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 Thu Dec 14 2000 - 06:51:42 CST