Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: cannot delete a procedure

Re: cannot delete a procedure

From: Alan <alan_at_erols.com>
Date: Fri, 24 Sep 2004 09:47:06 -0400
Message-ID: <2rimqoF1aqgnpU1@uni-berlin.de>

"Lenny" <non.te_at_la.dico> wrote in message news:UcJ4d.298549$OR2.13602455_at_news3.tin.it...
>
> > do it from sql*plus
> >
> >
>
> wow
> it worked
>
> drop function "nvisite30(nvisite)"
>
> ok!
>
> many thanks.
> it should be a bug in plsql
>
> Lenny
>
>

It's not a pl/sql thing. That's the way Oracle works- it's just not well known. You can break all kinds of rules with it. For example:

CREATE USER "6alan" identified by ...

It's also good for hiding things:

CREATE TABLE "my_table"...

Then do a select tname from tab. You will see the table name, but will not be able to do a DESC my_table or anything else unless you

DESC "my_table"

I strongly advise against doing any of this, as it will just cause YOU endless problems down the road. Received on Fri Sep 24 2004 - 08:47:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US