Re: Error 1414 OUT or INOUT argument is not a variable or NEW pseudo-variable in BEFORE trigger

[William Chiquito]

Hi Jorge,

My test:

DELIMITER $$

DROP PROCEDURE IF EXISTS `gettest`$$

CREATE PROCEDURE `gettest`(INOUT pvalor INT)
BEGIN
	SET pvalor = pvalor + 1;
END$$

DROP PROCEDURE IF EXISTS `gettest1`$$

CREATE PROCEDURE `gettest1`()
BEGIN
	CALL gettest(1);
END$$

DELIMITER ;

CALL gettest1();

Result:

Error Code : 1414
OUT or INOUT argument 1 for routine mydatabase.gettest is not a variable or NEW
pseudo-variable in BEFORE trigger
(0 ms taken)

Change:

DELIMITER $$

DROP PROCEDURE IF EXISTS `gettest1`$$

CREATE PROCEDURE `gettest1`()
BEGIN
	DECLARE a INT DEFAULT 0;
	CALL gettest(a);
	SELECT a;
END$$

DELIMITER ;

Result:

   a  
------
     1