DROP PROCEDURE statement

Syntax

Identifies
the particular procedure to be dropped, and is valid only if there is exactly
one procedure instance with the procedure-name in the schema. The identified
procedure can have any number of parameters defined for it. If no procedure
with the indicated name in the named or implied schema, an error (SQLSTATE
42704) will occur. An error will also occur if there is more than one specific
instance of the procedure in the named or implied schema.