The DROP PROCEDURE (drop_procedure_statement) SQL statement is not accepted by SAP MaxDB.
Use the DROP DBPROC statement (drop_dbproc_statement) in the SAP MaxDB database system to delete a database procedure.
SQL Statements: Differences