Drop a stored stand-alone procedure.
DROP PROCEDURE [schema.]procedure_name
"I kissed my first girl and smoked my first cigarette on the same day. I haven't had time for tobacco since" ~ Arturo Toscanini
Related Oracle Commands:
DBA_SOURCE ALL_SOURCE USER_SOURCE