MySQL Forums
Forum List  »  Stored Procedures

Re: Error 1414 OUT or INOUT argument is not a variable or NEW pseudo-variable in BEFORE trigger
Posted by: William Chiquito
Date: July 17, 2007 08:23AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Error 1414 OUT or INOUT argument is not a variable or NEW pseudo-variable in BEFORE trigger
9138
July 17, 2007 08:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.