From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Unable to validate/drop object
Date: Tue, 12 Dec 2000 21:20:46 +0100
Lines: 42
Message-ID: <9169dg$33spg$4@ID-62141.news.dfncis.de>
References: <78CC0C89B41DD311B8900000F6CB6A8E0CDD88@srvexch1.centraal.boekhuis.nl>
NNTP-Posting-Host: sybrandb.demon.nl (212.238.21.78)
X-Trace: fu-berlin.de 976660720 3273520 212.238.21.78 (16 [62141])
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300


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@centraal.boekhuis.nl> wrote in message
news: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.
>
>
>