Re: cannot delete a procedure

From: Alan <alan_at_erols.com>
Date: Thu, 23 Sep 2004 14:57:12 -0400
Message-ID: <2rgkk8F19hcocU1@uni-berlin.de>

"Dave" <david.sharples3_at_ntlXworld.com> wrote in message news:hHD4d.292$g11.222_at_newsfe4-gui.ntli.net...
>
> "Lenny" <lucascri_at_QUESTOLOTOGLItiscali.it> wrote in message
> news:ArD4d.19779$B06.1036_at_news.edisontel.com...
> >
> >> i've created a procedure like this
> >>
> >> create or replace function "nvisite30(nvisite)" return number is
> >>
> >
> > ooops......
> > a function...
> >
> > Lenny
> >
>
> show the full cut and paste of you trying to drop it
>
>

Use the double quotes and lower case (the way you typed it above). If you create something using double quotes, then the name is case-sensitive, and you must use the double quotes to tell Oracle that you are being case-sensitive. Received on Thu Sep 23 2004 - 13:57:12 CDT