Rename part of the parameter names of a procedure

0

I have some procedures where parameter names start with: "p _" . Is it possible to change in a unique way and code all the names of all procedures that start with this abbreviation by: "abc _" for example?

Procedure:

CREATE DEFINER = 'root'@'%' PROCEDURE 'postSac'(
        IN p_nome VARCHAR(255),
        IN p_telefone VARCHAR(15),
        IN p_email VARCHAR(100),
        IN p_cidade VARCHAR(100),
        IN p_estado VARCHAR(2),
        IN p_assunto VARCHAR(255),
        IN p_mensagem LONGTEXT
    )
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN

   DECLARE EXIT HANDLER FOR SQLEXCEPTION
      BEGIN
         SHOW WARNINGS;
         #SELECT 0 AS retorno;
         ROLLBACK;
      END;
   START TRANSACTION;

   INSERT INTO sac (nome, telefone, email, cidade, estado, assunto, mensagem) VALUES (p_nome, p_telefone, p_email, p_cidade, p_estado, p_assunto, p_mensagem);

END;
    
asked by anonymous 31.07.2017 / 19:05

1 answer

0

Unfortunately I ended up finding out that this is not possible:

  

This declaration can be used to change the characteristics of a   stored procedure. More than one change can be specified   in an ALTER PROCEDURE statement. However, you can not change the   parameters or the body of a stored procedure using this   declaration; To make these changes, you must drop and re-create the   procedure using DROP PROCEDURE and CREATE PROCEDURE.

link

    
31.07.2017 / 20:06