Re: Cannot drop function

From: <pbeatty_at_my-deja.com>
Date: Fri, 01 Oct 1999 16:44:26 GMT
Message-ID: <7t2od6$680$1@nnrp1.deja.com>

In article <37f49c8a.0_at_145.227.194.253>, "Mark G" <mgumbs_at_hotmail.com> wrote:
> You can rename a table, i'm not sure if you can rename a iew. Try it
then
> try dropping the function.
>
> M
>
> <pbeatty_at_my-deja.com> wrote in message
news:7t23lt$n0h$1_at_nnrp1.deja.com...
> > I have a function(and a view) in Oracle 8.0.5 that
> > I cannot drop. The function calls a view which
> > calls the same function. Both are invalid.
> > I have also tried to replace both with a new
> > function/view of the same name.
> > Trying to drop either gives ORA-00600.
> > Is there a way to get get these out of the
> > database?
> >
> > Thanks in advance.
> >
> > Paul
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

I cannot rename the view. I get an error of too many open cursors.

Paul

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 01 1999 - 11:44:26 CDT