Re: Passing values between stored procedures

[gustavo bellino]

how can i do to compare an IN parameter in a 'select where' sentences.

this is the code

CREATE PROCEDURE insertOpe (

--- CLIENTE TABLE

IN id_var INT,

---para la tabla OPERADOR

IN user_var char(10),
IN password_var INT(11),

OUT message VARCHAR(20))
BEGIN
---DECLARE count INT DEFAULT 0;
DECLARE V1 INT DEFAULT 0;
DECLARE exit handler for 1062 rollback;
set message := "Error";
start transaction;

select count(*)into v1 from operador op where
(op.dni=id_var); <----------------------------- HERE. It is rigth?
if (v1>0)then
set message := "op exist";
rollback;
else

insert Operador (user,password,dni)
select user_var,password_var,id_var;
commit;
set message := "OK";
end if;

END/