Re: Dropping an INVALID function/procedure...

Jonathan Wayne Ingram (jwingram_at_whale.st.usm.edu) wrote:
: Curtis Hanson (chanson_at_gpu2.srv.ualberta.ca) wrote:
: : I am trying to drop a function created through SQL*Plus (AIX
: : 2.1.4.0.0). While the function itself does not depend on any other
: : functions its status is 'INVALID'. I've tried dropping it both as
: : myself and as SYSTEM but SQL*Plus just goes off into La La Land
: : leaving me sitting there twiddling my thumbs...
 

: : HOW DO I GET RID OF THIS THING!!!
: Check to make sure that the object is in your schema. If you want to
: remove it as system, make sure that you specify the schema the object
: belongs to:
 

: drop <SCHEMA>.<FUNCTION>;
 

: Good luck :_)
 

: Jonathan

Might you need the drop any procedure privilege as well.

i.e.

The DBA may have to GRANT DROP ANY PROCEDURE TO youruserid;

Hope one of these helps

--
Murray Kaiser                  | Usual gutless disclaimer.. 
Nova Scotia Power              | Opinions are mine and not necessarily
(Murray.Kaiser_at_NSPower.NS.CA)  | shared by my employer