mysql "not a variable or NEW pseudo-variable" message

Question

I'm trying to create a procedure that will enter data and then return a message in the OUT parameter, however i'm getting this message "argument 5 for routine hospital.alextest10 is not a variable or NEW pseudo-variable in BEFORE trigger"

i have this as my procedure:

create procedure alextest10
(IN a_patid CHAR(3), IN a_patnam VARCHAR(12), IN a_consno CHAR(3), IN a_ward CHAR(2),
OUT a_message VARCHAR(50))
BEGIN
set a_message = 'Database updated';
INSERT INTO patient (patient_id, patient_name, consultant_no, ward_no)
values (a_patid, a_patnam, a_consno, a_ward);
end!

and this as my call command:

call alextest10 ('p99', 'Madeuppy', '999', 'w9', a_message)!

Can you help?

Much appreciated!

user1191247 · Accepted Answer · 2012-03-17T21:22:08.080

22

CALL alextest10 ('p99', 'Madeuppy', '999', 'w9', @a_message);
SELECT @a_message;

edited Mar 17 '12 at 21:22

answered Mar 17 '12 at 17:01

user1191247

10,808
2
22
32

this gets rid of the error message, but it's not bringing up the message, just adding the data. any ideas? – alexei7 Mar 17 '12 at 19:11
brilliant :) i thought the function did something else. working perfectly now, thank you both very much – alexei7 Mar 17 '12 at 22:13
1

how did you declare @a_message variable? – Jitendra Pancholi Nov 21 '16 at 12:36
@JitendraPancholi : were you able to figure out ? – j10 Aug 01 '18 at 11:11
@j10 sorry bro, don't remember now. – Jitendra Pancholi Aug 02 '18 at 04:50
@JitendraPancholi You don't declare user-defined variables, you just start using them. [See here](/a/11754790). – Jivan Pal Apr 29 '22 at 13:35

score -1 · Answer 2 · answered Mar 23 '20 at 08:41

-1

You should use registerOutParameter - in your case:

cStmt.registerOutParameter(5, java.sql.Types.VARCHAR);

where type of cStmt is CallableStatement.

answered Mar 23 '20 at 08:41

Peter Ershoff

1

2

This question does not mention Java at all. – Jivan Pal Apr 29 '22 at 13:35

mysql "not a variable or NEW pseudo-variable" message

2 Answers2

Linked