hplsql/src/test/queries/local/drop_proc.sql

CREATE PROCEDURE P1()
BEGIN
  PRINT 'P1';
END;

CREATE FUNCTION F1() RETURNS STRING
BEGIN
  RETURN 'F1';
END;

P1();
F1();

DROP PROCEDURE P1;
DROP PROCEDURE F1;

DROP PROCEDURE IF EXISTS P1;
DROP FUNCTION IF EXISTS F1;