Drop a stored stand-alone procedure.
  
  Syntax:
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:
CREATE PROCEDURE
  ALTER PROCEDURE
  
  Related Views:
 CODE_PIECES 
                                                         
 CODE_SIZE 
  
 DBA_SOURCE      ALL_SOURCE      USER_SOURCE