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