The CREATE PROCEDURE (create_procedure_statement) SQL statement is not accepted by SAP MaxDB.
Use the CREATE DBPROC[EDURE] statement (create_dbproc_statement) in the SAP MaxDB database system to create a database procedure.
SQL Statements: Differences