Re: Help dropping a procedure

Got it! Thanks for your help.

Aaron

In article <06fc3627.5c2a4b8d_at_usw-ex0102-015.remarq.com>,   Mark D Powell <mark.powellNOmaSPAM_at_eds.com.invalid> wrote:
> Aaron <asentell_at_my-deja.com> wrote:
> >I guess everybody else is stumped, too.
> >
> >In article <8lal76$5ec$1_at_nnrp1.deja.com>,
> > Aaron <asentell_at_my-deja.com> wrote:
> >> Somehow I created a procedure using TOAD under my schema
 called
> >> LACOMQA.PRE_LOAD_CLEANUP. (This is not under the LACOMQA
 schema, but
> >> under mine, ASENTELL.) I've been unsuccessful thus far in
 attempting
> >> to drop this procedure. Using full name,
> >> ASENTELL.LACOMQA.PRE_LOAD_CLEANUP, does not work, nor can I
 use TOAD's
> >> GUI interface to delete it. Any ideas?
> >>
> >> Thanks,
> >> Aaron
> >>
> Is this a database stored procedure or a packaged procedure?
> The name you show in your post is not a proper stored procedure
> name but I would take it to be a packaged procedure name. A
> period or dot is the separator character for owner to object to
> domain etc... so I suspect this is the problem. Now if this is
> a packaged procedure you would just drop the entire package.
>
> But assuming it is a procedure like you say then I would suggest
> selecting the sys.dba_objects rows for the object to verify who
> ownes it and the name Oracle stored the procedure under. Remove
> any synonyms or other objects that might be getting in the way.
> Then try logging on to sqlplus as the owner and issue the drop
> without prefixing it with the owner id. If the drop still fails
> then try enclosing the procedure name in double quotes as
> in 'drop procedure "X.Y"; '. That might do it, but remember
> that when double quotes are used on table_names and column_names
> Oracle preserves the contents of the quotes exactly including
> case so make sure you enter the same case as appears the in the
> sys.dba_object output.
>
> I hope this helps.
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 31 2000 - 00:00:00 CDT