To drop a stored procedure:
Packages
includes call specs for Java stored procedures
deployed in packages.
Functions
includes call specs for Java stored
procedures deployed as functions (that return a value).
Procedures
includes call specs for Java stored
procedures deployed as procedures (that do not return a value).
Copyright © 1997, 2004, Oracle. All rights reserved.