Remove it from the code and recompile the code..
Example:
Create or replace package foo
As
Function foo1 return varchar2;
Type m1 is ref cusor;
End foo;

Then if I don't want m1 any more :

Create or replace package foo
As
Function foo1 return varchar2;
End foo;

And run it against sqlplus or any other util you are using...

Regis


-----Original Message-----
From: Pedro Miguel Gonçalves [mailto:[Email Address Removed]
Sent: 01 April 2004 15:33
To: [Email Address Removed] how to drop a package member?

Hi guys,


How do I drop a package list member that is not in use anymore?





*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************

DB2 & UDB email list listserv db2-l LazyDBA home page